Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database Comparision

Author  Topic 

vijayakumar_svk
Yak Posting Veteran

50 Posts

Posted - 2011-07-27 : 14:05:11
We have 10 databases for an application (it is a huge product) on each environment (DEV,QA,Stage,Production). Developers will be doing changes in DEV databases.

We need to compare all 10 DEV DBs with QA to identify the differences. Is there any commandline toll that can be configured to run on a scheduled manner to compare the DBs and produce a report?

==============================
Work smarter not harder take control of your life be a super achiever

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-27 : 14:06:57
We use Red Gate's SQL Compare tool to do schema comparisons.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

vijayakumar_svk
Yak Posting Veteran

50 Posts

Posted - 2011-07-27 : 14:09:09
Thanks tkizer!!

We do using Red gate but is it possible to do non GUI based? I believe SQL Compare Pro has the command line option. Any other tool?

==============================
Work smarter not harder take control of your life be a super achiever
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-27 : 14:15:54
For command line: http://www.red-gate.com/supportcenter/Content?p=SQL%20Compare&c=SQL_Compare/help/7.0/4250.htm&toc=SQL_Compare/help/7.0/toc356444.htm

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-27 : 14:17:06
You could check out apexsql.com as well.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -