Comparing/contrasting twodatabases

Question

Comparing/contrasting twodatabases

newuser-795130

SSC Rookie

Points: 33
More actions
June 25, 2008 at 7:25 pm

#189617

I am rusty and would like some help in comparing and contrasting two large data bases.
This comparison would include all data in the tables and fields. could anybody give me direction in the proper sql commands to use?
Any suggestions would be greatly appreciated.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

There's a script in the script section that purports to compare two databases: http://www.sqlservercentral.com/scripts/Administration/62276/, but there are lots of affordable tools from RedGate, ApexSQL, etc. that make comparison easy.

Greg

GSquared SSC Guru Points: 260824 More actions · Answer 2

I'd use ApexSQL Diff for this. I haven't tried the RedGate product, but I'm sure it would do it just as well. (I have a lifetime free-upgrades license for most of the Apex products, so I tend to use theirs.)

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Buy a tool. Most of them are cheap and they do a good job. this isn't a hard task, but it's easy to make mistakes. For $300 or so, you can't write one that does the job well.

Vijaya Kadiyala SSCrazy Eights Points: 9149 More actions · Answer 4

Hi,

You can use some tools to compare the tables/schemas/databases but how would you compare the data in those tables? If databases are really then !!..

But first of all why one want to compare the database, if there is any issue with the data quality then it should be specifc to the some tables.

i would appreciate if any body can answers these questions.

Thanks -- Vj

http://dotnetvj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

davros30 SSC Veteran Points: 273 More actions · Answer 5

There are many tools on the market that will do this job for you. Some are fairly expensive.

There is one that is very inexpensive. From around $20 US you can purchase SQLC[/url]. There is also a trial version for free to evaluate.

FridayNightGiant SSCertifiable Points: 7151 More actions · Answer 6

Vijaya Kadiyala (6/27/2008)

Hi,

You can use some tools to compare the tables/schemas/databases but how would you compare the data in those tables? If databases are really then !!..

But first of all why one want to compare the database, if there is any issue with the data quality then it should be specifc to the some tables.

i would appreciate if any body can answers these questions.

Thanks -- Vj

http://dotnetvj.blogspot.com[/quote%5D

The comparison tools you can buy will usually compare data as well.

There are many reasons why you would want to compare databases. For example differences between Dev and Production, differences between a customer/client version of a database and a master version.

davros30 SSC Veteran Points: 273 More actions · Answer 7

Just a quick update, SQLC is now in Beta version and is free to evaluate the full version.

You can download it here http://sqlc.azurewebsites.net/[/url]