February 3, 2010 at 11:29 am
I have database called "Employee_Lookup" in 5 different servers. Now i want to consolidate them into 1 database in a single server. Each database in 5 locations have many common tables but some have more tables and some have less.
Before doing that I check the differece between each database with respect to tables and the data. is theere an easy way to report these chagnes and synch them. Can i use TableDiff.exe Cmd line utitlity to do so?
February 3, 2010 at 11:32 am
SQL Compare from Redgate would be an option..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 3, 2010 at 12:25 pm
I am not looking for any 3rd party tool and i dont have any intention to buy, just want to do this using existing sql tools as this is only for one time.
February 3, 2010 at 12:39 pm
You could script each database to a file (http://msdn.microsoft.com/en-us/library/ms178078.aspx) and then use file compare in DOS prompt to look at the differences.
This would work if you don't care about the data in each database right off, just that the structure of the databases are the same.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 3, 2010 at 2:05 pm
Tara-1044200 (2/3/2010)
I am not looking for any 3rd party tool and i dont have any intention to buy, just want to do this using existing sql tools as this is only for one time.
You can download a fully functional trial edition for your one time task. Evaluate the product and then make the decision on whether or not you would ever use it again.
Other companies also have similar tools and there are free tools to do the same thing available.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply