How to compare two the same tables in different Database

Question

Post reply

How to compare two the same tables in different Database

..+ hunter +..

Mr or Mrs. 500

Points: 533
More actions
June 3, 2009 at 11:54 am

#205487

any help on how can i compare two the same table in different database?
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

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

Mayank Khatri SSCertifiable Points: 7934 More actions · Answer 1

Mayank Khatri

SSCertifiable

Points: 7934

June 3, 2009 at 11:58 am

#1004203

Do a search on TableDiff utility in google.

GSquared SSC Guru Points: 260824 More actions · Answer 2

RedGate has a product that will do that for you.

So does ApexSQL.

Those are your best bets for getting it done fast and right.

- 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

..+ hunter +.. Mr or Mrs. 500 Points: 533 More actions · Answer 3

Thank you guys,

I download a the said utility but i ot the following error.

" Invalid object name 'dbo.tblsmpreferenceuser'."

Mayank Khatri SSCertifiable Points: 7934 More actions · Answer 4

which utility did u download. If its Tablediff, it comes with SQL installation and usually installed here:

"C:\Program Files\Microsoft SQL Server\90\COM\TableDiff.exe"

http://weblogs.sqlteam.com/mladenp/archive/2007/03/03/60125.aspx

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 5

You'll have to provide more information about what you did. Make sure the table name and schema is correct, and that the user has permissions to see the table.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com