How to run comparison without leaving the SQL Server Management Studio?
For instance, you develop business logic based on stored procedures of SQL Server
and constantly upload these procedures to the production server. You definitely
run SQL Examiner and perform the necessary tasks.
However, you can now take advantage of all the many opportunities that SQL Examiner
offers without leaving the development environment. You can integrate the SQL Examiner
Console Mode into the SQL Server Management Studio.
In SQL Server Management Studio, select External Tools... in the Tools menu and, in
the dialog box that appears, add a new item:
- Title: Compare Prod and Dev Databases
- Command: C:\Program Files\SQL Accessories\SQL Examiner Suite\SQLExaminer.exe
- Arguments: /server1: (local) /db1:IssueTracker /WinAuth1 /server2: RemoteServer /db2:IssueTracker /WinAuth2 /report:stdout /reportOn:Different, OnlyInDb1, OnlyInDb2
- Tick the "Use Output window" checkbox
This command will compare the IssueTracker database on the RemoteServer and on the local server
and display the difference report in Output Window.
Now we have a new menu item in the Tools menu:
If you select this item, the Output Window will appear, and the comparison results will be displayed as text:
SQL Examiner command line tool. Version 2.1.0.76
table [dbo].[Customers]: The table exists only in first database.
table [dbo].[IssueTracker_EntryLog]: The tables differ in columns.
table [dbo].[IssueTracker_Permission2SecurityObjects]: The table exists only in first database.
table [dbo].[IssueTracker_Permissions]: The table exists only in first database.
table [dbo].[IssueTracker_ProjectPriorities]: The tables differ in columns, constraints.
table [dbo].[IssueTracker_Queries]: The tables differ in columns, constraints.
table [dbo].[IssueTracker_Rates]: The table exists only in second database.
table [dbo].[IssueTracker_Role2SecurityObjects]: The table exists only in first database.
procedure [dbo].[IssueTracker_Areas_CanDelete]: The procedure exists only in first database.
procedure [dbo].[IssueTracker_Areas_Create]: The procedures differ in body.