SQL Server DB comparison utilities

[sergeiY]

Hi

I need to make a lot of content (not structure) changes to one SQL Server2000 DB. Later on I would need to push these changes to production DB. What I was thinking I would do all my changes to db contents and then will compare new db to back up and somehow script all the changes and then push it to production DB via these scripts. Am I unrealistic with this vision? Are there any tools that may help me achive this? Or maybe there are some other ways I can do it easier and less painful. Mind you I will not be able to run DTC wizards to production. I can only execute SQL scripts.

Any help will be greatly appreciated.

 

[mrdenny]

SQL Profiler can record your T/SQL commands and let you save the script and execute it later against another server.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[AtomicWedgie]

Hi,

at

http://www.sqlservercentral.com/

there is a review of database comparison tools, released today. Registration to the site is free. I haven't read the document but maybe it can help.

Regards,

Atomic Wedgie

 

[AtomicWedgie]

Hi,

i just downloaded an sql compare trail version from

http://www.red-gate.com.

It's a fully functional 14 days trialperiod tool. I just used it myself for the first time and i must say it works great and saved me a lot of time checking 2 databases.

When you have compared your databases you can then synchronise the 2 databases so that it incorporates all changes from one database to the other.

Regards,

Atomic Wedgie

 

[sergeiY]

Thank you guys I will look into this red-gate tool looks promising.
Thank you

Sergei