November 8, 2010 at 7:57 am
I have 50 instances in my production environment and i have a common database in all the instances.
My question is how can i find what are all the differences in the databases across all the instances like (tables, store Procedures, keys, constraints, functions.....etc).
How do i find the difference? Is there any script to find the differences.
Thanks,
Rahul.
November 8, 2010 at 8:01 am
Rahul
I think the easiest way for you to do this is to use a third party tool such as Red Gate's SQL Compare. (I don't have any interest in promoting this software, and I'm sure that other vendors provide similar tools.)
John
November 8, 2010 at 2:00 pm
Like John, (I am not promoting this particular product) we use a third party application called Apex SQL Diff to keep our DEVSQL and SQLQA servers in check. Extremely handy and can script out the differences for you to review.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 17, 2010 at 1:04 pm
Use any 3rd party database comparison and synchronization software. I recommend to try our tool - SQL Examiner Suite, but any tool listed here can help you.
November 18, 2010 at 12:24 pm
thanks all.
January 26, 2011 at 12:43 pm
I used the red gate tool (SQL compair) and it is very help full to find out all the differences between the databases.
Thanks again:-)
Rahul
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply