You can automate executing the scripts using the command line.
Type cmd in the Search programs and files text box and press the ENTER button.
Type a path to the datacompare.com file located in the dbForge Data Compare for MySQL installation folder on your PC, and press the SPACE key.
C:\Program Files\Devart\dbForge Data Compare for MySQL\datacompare.com
To execute the corresponding script, use the /execute command, and press the SPACE key.
C:\Program Files\Devart\dbForge Data Compare for MySQL>datacompare.com /execute /?
Specify connection details of the server where to execute the script.
C:\Program Files\Devart\dbForge Data Compare for MySQL>datacompare.com /execute /connection:"User Id=root;Host=db;Port=3320;Database=test;Character Set=utf8"
Specify the script file.
C:\Program Files\Devart\dbForge Data Compare for MySQL>datacompare.com /execute /connection:"User Id=root;Host=db;Port=3320;Database=test;Character Set=utf8" //inputfile: "script.sql"
Specify the password.
C:\Program Files\Devart\dbForge Data Compare for MySQL>datacompare.com /execute /connection:"User Id=root;Host=db;Port=3320;Database=test;Character Set=utf8" /inputfile: "script.sql" /Password:mypsw
To hide the command line window, use the /quiet command. (Useful for batch files).
C:\Program Files\Devart\dbForge Data Compare for MySQL>datacompare.com /execute /connection:"User Id=root;Host=db;Port=3320;Database=test;Character Set=utf8" /inputfile: "script.sql" /Password:mypsw /quiet
If you use the /argfile argument, all the following commands are specified inside an argfile:
~~~
/execute
/connection:"User Id=root;Host=db;Port=3320;Database=test;Character Set=utf8"
/inputfile: "script.sql"
~~~
In this case, the command line string will be written as follows:
~~~
C:\Program Files\Devart\dbForge Data Compare for MySQL>datacompare.com /argfile:myarg.txt
~~~
Select corresponding command line switches to perform the required operations: