Automate comparison of database snapshots

The /schemacompare command lets you compare two snapshots, or compare a snapshot with a database from the command line.

Syntax

dbforgesql.com /schemacompare [/option_name1[:value | [parameter1:value parameter2:value ..]] /option_name2 ..]

Note

To run dbForge Studio CLI commands, open Command Prompt and navigate to the folder that contains dbforgesql.com. The default path to this executable depends on where dbForge Studio for SQL Server is installed. If you installed dbForge Studio:

• As a standalone tool

C:\Program Files\Devart\dbForge Studio for SQL Server

• As part of the dbForge Edge bundle

C:\Program Files\Devart\dbForge Edge\dbForge Studio for SQL Server

Get command-line help

To view the list of switches available for /schemacompare, run the following command:

dbforgesql.com /schemacompare /?

Command details

• To compare the two snapshots, run the /source snapshot and /target snapshot commands.

dbforgesql.com /schemacompare /source snapshot:"<full_path_to_source_snapshot.snap>" /target snapshot:"<full_path_to_target_snapshot.snap>"

• To compare a snapshot with a database, run the /source snapshot:<file_path> and /target server:<name> database:<db> [user:<name>] [password:<pw>] commands.

dbforgesql.com /schemacompare /source snapshot:"<full_path_to_source_snapshot.snap>" /target connection:"Data Source=<target_server>;Integrated Security=False;User ID=<target_username>;database=<target_database>"

For a complete list of command-line switches, see Command-line switches.