Page History

IDERA Idera SQL Schema Compare command line allows is a set of tools that allow you to compare and synchronize database schema SQL Server databases via the command line.

With the command line you can:

• Perform automated schema comparison and synchronization;
• Compare live SQL Server databases or database snapshots;
• Compare and synchronize database schema databases as part of your setup and deployment solution;
• Compare database schemas databases and execute the synchronization scripts script in batch files;
• Schedule the database comparison.

All command line settings are specified in an xml config file. You can create an xml config file via one of the following methods:

• Using the SQL Schema Compare command line wizard. You can access the wizard from the start menu, under Start > All Programs > IDERA > SQL Comparison Tools > Command Lines.
• Using the SQL Schema Compare interface. Simply compare the databases for which you wish to create a command line config file, set the options and other comparison preferences and click Create a command line config file in the Ribbon, context menu or in the right panel.
• Manually, using any text editor, such as Notepad.

The command line includes:

• A wizard for generating the command line xml config file.
• The command line utility, that uses the xml config file to compare and synchronize SQL Server databases.

We included command line samples for the most common scenarios, in order to help you get started. The sample xml config files are located in the toolset installation folder, usually under \Program Files (x86)\Idera\SQL comparison toolset v<n>\Command Line Samples\Schema Compare\, where v<n> is the toolset version numberThe command line comes with samples for most typical data comparison scenarios. The sample configuration files are located under \Program Files\Idera\SQL Comparison Toolset\Command Line Samples\SQL Schema Compare\.