Setting SQL Data Compare Options

The Application Options dialog box enables you to specify options such as the application that SQL Data Compare uses to open the synchronization SQL script or the location where that script is saved.

To display the Application Options dialog box, on the Tools menu, click Application Options.

To specify the application in which SQL Data Compare opens SQL scripts:

Under SQL Viewer Application, select the application.
If you have selected Custom program, type the path for the Executable file, or click Browse to choose the file.
In the Arguments box, type the arguments so that SQL Data Compare can connect to your database. Refer to your SQL application's documentation for information about the required arguments.
Click OK to save your settings.

To specify the location where SQL scripts are saved:

Under Saving SQL Scripts, select the Auto save SQL scripts check box if you want SQL Data Compare to save the scripts automatically.
Selecting the check box ensures that the Save a copy of the SQL script before synchronization check box is selected by default in the Confirm page of the Synchronization Wizard.
Select the required character encoding in the Encoding list.
Type the path for the SQL script folder, or click Browse to choose the folder.
Click OK to save your settings.

To specify the export defaults:

Under Export Defaults, clear the Include tables or views that contain only identical rows check box if you do not want SQL Data Compare to select these tables or views for export.
This ensures that the Export check box is cleared by default on the Export Comparison Results dialog box for tables or views that contain only identical rows.
Select the required character encoding in the Encoding list.
Type the path for the Export folder, or click Browse to choose the folder.
The Export folder is the default folder for Export to on the Export Comparison Results dialog box.
Click OK to save your settings.