Hi everyone,
I'm about to implement some changes to a production database and application. The new version of the system has tables that did not exist in the old version.
I'm looking for the best way to copy these tables to the production database, keeping the data intact.
If I copy the tables (the individual dbf files) into the production location, the files will still have references to the DBC on my development system (or so I believe).
I would then use the FREE command, but there the following warning in HELP:
FREE TABLE should never be issued to remove a table from a database if the database exists on disk. If the database exists on disk, FREE TABLE may render the database unusable. Use REMOVE TABLE instead. Unlike FREE TABLE, REMOVE TABLE removes all references from the database to primary indexes, default values, and validation rules associated with the table.Of course, I don't desire to render my development database unusable.
Is it better to right scripts to create the tables in the prod. DBC, then append the records from the development tables? If so, any specific pointers would be great.
Any advice in this area is very much appreciated...I've had problems coming up with an easy way to handle this in the past.
Thank you,
Steve Gibson