Posted by xman on 08/31/07 12:09

On Aug 30, 8:10 pm, "RichardLamont" <u37070@uwe> wrote:
> 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 Developmentdatabase
> 2. Delete the Developmentdatabase
> 3. Restore the Developmentdatabaseas Development_Backup
> 3. Use the the sqlscriptto create the new Developmentdatabase
> 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

Hey Richard,

you should check out xSQL Software's xSQL Object and xSQL Data Compare
(http://www.xsqlsoftware.com) - they allow you to both compare and
synchronize the two databases you are working with. The process is
very simple and straight forward - you run a compare, view the
differences, automatically generate the script that will push the
changes on the direction you want to and finally execute the script.
You can also the associated command line utilities to automate the
process of propagating the changes from one environment to the
other.

And here is the best part - xSQL Bundle which includes xSQL Object and
xSQL Data Compare is:
- free for SQL Server Express;
- free for smaller databases (based on the number of objects in the
database)
- and of course you have the two weeks of free trial for any SQL
Server Edition and any size database

Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com

[Back to original message]