Comparing Database Snapshots through Command Line

This topic describes how to compare two snapshots, and a snapshot with a database using the command line.

Comparing two snapshots through the command line

To compare two database snapshots through the command line, do the following:

  1. Click Start, and type cmd in the Run line. Press ENTER. The Command Prompt opens.

  2. Type a path to the dbforgesql.com file (note that the .com extension can be omitted in the command line), located in dbForge Studio for SQL Server installation folder on your PC, and press the space bar.
    "C:\Program Files\Devart\dbForge Studio for SQL Server\dbforgesql.com"
    
  3. Specify the snapshots you want to compare:
    C:\Program Files\Devart\dbForge Studio for SQL Server>dbforgesql.com /schemacompare /source snapshot:"d:\test\source.snap" /target snapshot:"d:\test\target.snap"
    
  4. Press ENTER to run the process.

    Tip: To obtain information on switches, type the following in the command line:

    C:\Program Files\Devart\dbForge Studio for SQL Server>dbforgesql.com
    

    More examples can be obtained by typing the following:

    C:\Program Files\Devart\dbForge Studio for SQL Server>dbforgesql.com /schemacompare /?
    

Comparing a snapshot with a database through the command line

To compare a snapshot with a database through the command line, do the following:

  1. Open Command Prompt by pressing Win+R, and typing ‘cmd’ in the Open line.
  2. Type a path to the dbforgesql.com file (note that the .com extension can be omitted in the command line), located in dbForge Studio for SQL Server installation folder on your PC, and press the space bar.
    "C:\Program Files\Devart\dbForge Studio for SQL Server\dbforgesql.com"
    
  3. Specify the snapshot and the database you want to compare:

    C:\Program Files\Devart\dbForge Studio for SQL Server>dbforgesql.com /schemacompare /source snapshot:"D:\snapshot\snapname.snap" 
    /target connection:"Data Source=DBMSSQL\MSSQL2012;Integrated Security=False;User ID=sa;database=AdventureWorks"