2016/02/10

How to compare sql server databases structure and data ?


  1. Install SQL Server Data Tools component https://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx in your Visual Studio version. 
  2. Show Sql Server Object Explorer in Visual Studio - View -> SQL Server Object Explorer
  3. Connect to server where one of your db is maintained in SQL Server Object Explorer Window
  4. Right click on the database and choose "Schema compare.." or "Data comparison"

Posted by at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)