>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.

Wim,

I'm using xCase for this and many other things. Others have mentionned Stonefield which is an excellent product. If you can afford it, buy the 2. xCase for the initial stage of the project and Stonefield for maintenance. I have a file in my web (see download page) that explains how these products work.

José