Automatic data comparison and synchronization from the command line

You can automate data comparison and synchronization using the command line.

Running Comparisons from the Command Line

  1. Click Start.
  2. Type cmd in the Search programs and files text box and press the ENTER button.

Note

To run the 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 desktop mode, press the Windows + R keys, to show the Run command line.
  1. Type a path to the dbforgemysql.com file located in the dbForge Studio for MySQL installation folder on your PC, and press the SPACE.
C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.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 MySQL>dbforgemysql.com
  1. Specify command line arguments (connection strings and actions you want to run).

For example, specify the type of the operation.

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /?
  1. Specify the objects that will be compared and synchronized.
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"D:\mycompdoc.dcomp"
  1. Synchronize data directly into the database and generate a synchronization script file.
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"D:\mycompdoc.dcomp" /sync:"D:\mysync.sql"

Note

To synchronize data automatically, use /sync without file name specification:

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"D:\mycompdoc.dcomp" /sync
  1. Generate a comparison and synchronization protocol into a file.
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"D:\mycompdoc.dcomp" /sync:"D:\mysync.sql" /log:"D:\mylog.log"
  1. Compose a comparison report.
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"D:\mycompdoc.dcomp" /sync:"D:\mysync.sql" /log:"D:\mylog.log" /report:"D:\myreport.html"
  1. Specify the report format. HTML and EXCEL formats are available.
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datacompare /compfile:"D:\mycompdoc.dcomp" /sync:"D:\mysync.sql" /log:"D:\mylog.log" /report:"D:\myreport.html" /reportformat:HTML
  1. Press ENTER to run the process.

Tip: To execute the synchronization script, use the /execute switch:

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /execute /connection:"User Id=yourusername;Host=db;Port=3320;Database=test;Character Set=utf8" /inputfile:"D:\mysync.sql"

Generate File With Command Line Arguments

To generate a file with command line arguments, open the Data Comparison wizard.

To access the Data Comparison Wizard, on the Comparison menu, click

Select Source and Target for comparison. Go through other wizard pages to tune the data comparison.

On the Options tab, click Save settings to a command line arguments file and specify the file name and location to save the file. The selected Source and Target connection strings along with comparison options will be saved as command line arguments in the file. You can edit the values of comparison options in the file.

Note that the generated file does not contain password information for security purposes. You should edit the file and enter the passwords manually.

You can see available additional arguments and learn how to use them in the Additional /datacompare Arguments topic.

The command line string with /argfile parameter will be written as follows:

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /argfile:file_name.txt

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
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 MySQL?
Download a free 30-day trial