Posted by RichardLamont on 08/31/07 00:10

We often have to migrate changes to sql server 2000 databases from
development to production. Normally we dump the sql from Enterprise Manager
for production and development and do a diff (using CSDiff - downloadable for
free).

From the diff information we create some scripts to add new tables or alter
existing tables as required. This is time consuming and error-prone.

I am now trying the following:
1. Backup up the Development database
2. Delete the Development database
3. Restore the Development database as Development_Backup
3. Use the the sql script to create the new Development database
structure from scratch
4. Use Data Transformation Services to migrate the data from
Development_Backup

The problem is that many of the 'sys' tables are empty. For example table
'sysforeignkeys' is empty.

Is there an easy way to rebuild the data in the 'sys' tables?

Thanks

[Back to original message]