Opening Synchronization Script in SQL Server Query Analyzer or Management Studio

DBChangeManager also offers an option to open the generated Synchronization script in Microsoft SQL Server provided SQL clients, which could either be Query Analyzer or Management Studio depending on whether you use SQL Server 2000 or SQL Server 2005.

Opening SQL Client

In Step 2 of the Synchronization dialog (viewing "Synchronization Details") you would see a link "Open in SQL Client" at the top right corner. Clicking the link will open the Synchronization script in either Query Analyzer or Management Studio based on whether you use SQL Server 2000 or SQL Server 2005.

Once the script is opened, you could view, edit or execute the script from within Query Analyzer or Management Studio. DBChangeManager will also pass the authentication details of the destination database to the SQL Client (Query Analyzer or Management Studio) for execution. Hence you do not have to re-login into the destination database for executing the synchronization script.

Conditions in which "Open in SQLClient" would work

You could open the Synchronization script in SQL Server SQL Client from within DBChangeManager only in the following scenario:

• DBChangeManager User Interface (Client) is accessed with a browser from the machine in which DBChangeManager Server is installed
• DBChangeManager Server should be installed in a machine which contains a Microsoft SQL Server installation

You would see the link "Open in SQLClient" in the Synchronization dialog only in the above scenario. This link would not be seen in scenarios where any of the above condition is not met.

Setting the path for SQL Client

By default DBChangeManager server will try to check for whether SQL Server is installed in that machine under the following directory:

C:\Program Files\Microsoft SQL Server

If its found then, it will automatically fetch the path for Query Analyzer executable or Management Studio executable and use the same for opening the Synchronization script.

In case if SQL Server is not installed in the above path, then it will prompt a settings dialog as shown below to provide the path of either Query Analyzer or Management Studio.

In the above dialog, browse and specify the path of Management Studio or Query Analyzer executable file (.exe file). You can also specify the path of other third party SQL Server client executables that can open the sync script file. When you use other third party executables, specify the argument name (like -f) that should be used as command line input for opening the sync script. Arguments are not required when you are opening SQL Server Management Studio or Query Analyzer to execute the sync script.