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 2008 Forums
 SQL Server Administration (2008)
 Database Comparison

Author  Topic 

sqlmyworld
Starting Member

38 Posts

Posted - 2011-10-18 : 19:27:35
I have two similar databases on SQL Server 2008 and I want to compare one database to another database by number of rows and content with each table. Is there any way I can do this comparison to prove that both databases have same values in all tables?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-18 : 21:17:37
Do you have Red Gate SQL Compare and SQL Data Compare?

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

Subscribe to my blog
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-10-19 : 04:25:51
VS 2010(Ulitame and Premium Edition) comes with a nice inbuilt Comparision tool.

PBUH

Go to Top of Page
   

- Advertisement -