Comparing Database Snapshots through Command Line

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

Note

Synchronization to a database snapshot is impossible. You can generate a synchronization script only by specifying the output file path in the /sync switch.

Comparing two snapshots through the command line

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

  1. Open Command Prompt by pressing Win+R, and typing cmd in the Open line.

    Note

    To run Command Line in Windows 8:

    From the Desktop Mode

    • Move the mouse cursor to the exact lower left corner until the desktop shortcuts menu appears
    • Right-click to see the shortcut menu and than click Run

    From the Charms Bar

    • Move your mouse to the upper right corner until the Charms Bar appears
    • Select Apps from the list and type run in the search box
    • Click Run from the search results

    Use Windows + R Shortcut Keys

    • In the desktop mode, press Windows key + R to show the Run command line.
  2. Type a path to the dbforgeoracle.com file (note that the .com extension can be omitted in the command line), located in dbForge Studio for Oracle installation folder on your PC, and press the SPACE bar.

     "C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com"
    
  3. Specify the snapshots you want to compare:

     C:\Program Files\Devart\dbForge Studio for Oracle>dbforgeoracle.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 Oracle>dbforgeoracle.com
    

    More examples can be obtained by typing the following:

     C:\Program Files\Devart\dbForge Studio for Oracle>dbforgeoracle.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 dbforgeoracle.com file (note that the .com extension can be omitted in the command line), located in dbForge Studio for Oracle installation folder on your PC, and press the SPACE bar.

     C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com
    
  3. Specify the snapshot and the database you want to compare:

     C:\Program Files\Devart\dbForge Studio for Oracle>dbforgeoracle.com /schemacompare /source snapshot:"D:\snapshot\SCOTT.snap" /target connection:"User Id=scott;Server=dboracle;Unicode=True;Connection Timeout=0;Direct=True;Service Name=orcl1120;" /schemas:SCOTT,SCOTT
    
  4. Press ENTER to run the process.