Command Line Wizard

Schema Compare incorporates a built-in Command Line Wizard that allows converting the project’s comparison and synchronization options into command-line syntax and save it as a *.bat file.

It is a very convenient feature when it comes to scheduling or automating database comparison and synchronization. You can then use a *.bat file with a script and Windows Task Scheduler or any other task scheduler tool available to schedule the database comparison or synchronization.

You can select command-line file settings to manage *.bat file text in the Command line execution file settings window. You can open the window by clicking the Save Command Line button in:

  • New Schema Comparison Wizard

Save Command Line button

  • Schema Synchronization Wizard

Save Command Line button

Options of the Command Line Wizard

The command line wizard has the following options:

Option Description
Comparison project You can use this option to load command line settings from *.scomp project file
Source The option helps to specify the source for comparison, including server name, connection details, user name, password, and a source type
Target The option helps to specify the target for comparison, including server name, connection details, user name, password, and a target type
Comparison options You can use this option to set options to manage comparison process
Report The option helps to specify the format and a path to a report file
Log File You can use this option to define whether to generate a log file on comparison or synchronizations as well as specify a path to it
Synchronization With this option you can select to launch a database synchronization, configure its options, and specify a path to synchronization file
Error code You can use this option to enable the processing of error levels
Arguments file If you specify a path to the arguments file, the program will generate a separate command-line file

Command line settings

After setting the required options for the potential script, you can click Validate to check the accuracy of the code.

If the syntax is valid, you receive the following message:

Validate code

Otherwise, the correspondent warning will be displayed:

Code warning

After validating the code, you can save the script as a *.bat file by clicking the Save button and specifying a path to its location.