patternsqlMinor
What SSMS and/or Visual Studio tools sync SQL Server environments?
Viewed 0 times
ssmsvisualwhatsqlserverstudioandtoolsenvironmentssync
Problem
I need to sync table structures, stored procedures, triggers, data, etc. between environments. There are dev, QA, and production environments. I am in a Microsoft-centric environment.
What tools within SSMS and/or Visual Studio can sync SQL Server machines/databases? Thanks.
What tools within SSMS and/or Visual Studio can sync SQL Server machines/databases? Thanks.
Solution
I found a Schema Compare utility in Visual Studio. It is included with the premium, ultimate, and perhaps other editions of Visual Studio.
To use it:
This utility is awesome. It is like WinMerge or BeyondCompare but optimized for SQL Server database objects. This should definitely be better known within the DBA and developer communities. I've worked with MS development tools since 1993 and just learned about it today. Cheers!
To use it:
- Open Visual Studio
- Click "Data" on the menu bar
- Click "Schema Compare"
This utility is awesome. It is like WinMerge or BeyondCompare but optimized for SQL Server database objects. This should definitely be better known within the DBA and developer communities. I've worked with MS development tools since 1993 and just learned about it today. Cheers!
Context
StackExchange Database Administrators Q#23417, answer score: 2
Revisions (0)
No revisions yet.