Merge Two Databases

[link9]

Hello all,

I have a new system that I've been developing parallel to an existing system.

The new system started off with the same database (a copy of it, rather) as the original, but has since undergone significant changes. Existing tables have been changed, new procedures/views written, etc. and so forth.

Now the new system is working and it's time to merge the two together.

The only thing I've been able to do thus far is select the differences in dbo.sysObjects table to find out what's new in the new db, but is there an equally easy way to find out what's changed between the two databases?

For instance, if a column name or datatype has changed in a table with the same name, is there some way for me to run a query between the two databases that would spit this type of information out to me?

SQLServer2000 is the dbms.

Thanks for any insight.


-paul

 

[fluteplr]

Not easily.

Here are your options.

1. Free, slow and painful.

Use Enterprise manager to script both databases and use a code comparison tool like windiff to find the differences.

2. Fast, slightly buggy and moderate price

Look at a product called SQL Compare from Red Gate Software.

3. Fast, more robust and less buggy than 2, very expensive.

Look at Change Manager from Embarcadero Software.