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.
To compare two database snapshots through the command line, do the following:
Open Command Prompt by pressing Win+R, and typing cmd in the Open line.
Note
To run Command Line in Windows 10:
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.
- In the window that opens, type cmd and press Enter.
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"
Note
The path to the executable file will differ depending on how you have installed the Studio - as a standalone tool or as part of the dbForge Edge bundle. Make sure that you have specified a correct path. If you have installed the Studio as part of dbForge Edge, change the path accordingly:
C:\Program Files\Devart\dbForge Edge\dbForge Studio for Oracle>dbforgeoracle.com
C:\Program Files\Devart\dbForge Studio for Oracle>dbforgeoracle.com /schemacompare /source snapshot:"d:\test\source.snap" /target snapshot:"d:\test\target.snap"
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 /?
To compare a snapshot with a database through the command line, do the following:
C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com
C:\Program Files\Devart\dbForge Studio for Oracle>dbforgeoracle.com /schemacompare /source snapshot:"D:\snapshot\SCOTT.snap" /target connection:"User Id=yourusername;Server=dboracle;Unicode=True;Connection Timeout=0;Direct=True;Service Name=orcl1120;" /schemas:SCOTT,SCOTT