June 3, 2009 at 11:54 am
any help on how can i compare two the same table in different database?
Thanks
June 3, 2009 at 11:58 am
Do a search on TableDiff utility in google.
June 3, 2009 at 11:59 am
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
June 3, 2009 at 12:13 pm
Thank you guys,
I download a the said utility but i ot the following error.
" Invalid object name 'dbo.tblsmpreferenceuser'."
June 3, 2009 at 12:20 pm
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
June 3, 2009 at 12:28 pm
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.
June 3, 2009 at 12:38 pm
Hi Guys,
I already resolve my issue with the tablediffutility
This tool is so great!thanks for sharing it with me
MwaaaH
June 3, 2009 at 12:52 pm
nice
June 3, 2009 at 3:09 pm
It's customary to post what was wrong and what you did. Someone might need the information to solve their issue.
June 3, 2009 at 4:22 pm
Steve Jones - Editor (6/3/2009)
It's customary to post what was wrong and what you did. Someone might need the information to solve their issue.
With the number of users growing almost exponentially, perhaps an editorial on user guidelines (rather than rules) could be in order?
.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply