|
Hi , How to compare the two database, and get the different tables,store procedures. it is possible in SQL 2005. Any one can help me.
(comments are locked)
|
|
It is but you'll need a third party tool like SQL Data Compare or Capacity Manager.
(comments are locked)
|
|
you can query the INFORMATION_SCHEMA view for the information you want. Or you can also check out OpenDBDiff at http://opendbiff.codeplex.com/
(comments are locked)
|
Your answer
Why do you need to know this? Taken over responsibility for a new server? Trying to deploy a new version to an existing database? Something else?