Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upgrading our customer's dbc/dbf database
Message
From
28/12/1998 17:30:31
Eric Barnett
Barnett Solutions Group, Inc
Sonoma, California, United States
 
 
To
28/12/1998 15:51:19
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00170927
Message ID:
00170967
Views:
20
You could always use DDL (ALTER TABLE) commands to modify the structure programatically. If you are so inclined you could write an application that would look at the new structure, compare it with the old structure, and generate the DDL code on the fly. You can also use the NOVALIDATE clause if you want to ignore the SP stuff. You can also modify stored procedures programatically with APPEND PROCEDURES.

>When deploying new database structures of applications that are already in use by our customers, we want to upgrade the dbc and the accompaning dbf structures, without erasing their live data.
>
>We tried to by making an empty copy of our own developer's database, moving the customer's data in a backup dir, placing our empty (new) one in the data directory and with an "append from" statement to add the live data into the new structure (added fields will then be left blank; that's not a problem).
>
>The problem is that during the data-import the stored procedures are triggered and cause multiple errors, ending in a complete mess....
>
>We're eager to hear other people's experiences and possible third-party products that make it possible to 'weave' an old (data-carrying) database with a new (empty) one.
Eric Shaneson
Cutting Edge Consulting
Previous
Reply
Map
View

Click here to load this message in the networking platform