How to compare 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"
  1. 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"
  2. 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"
  1. 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=yourusername;database=AdventureWorks"

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?
Download a free 30-day trial