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.
C:\Program Files\Devart\dbForge Data Generator for MySQL\datagenerator.com
C:\Program Files\Devart\dbForge Data Generator for MySQL>datagenerator.com /execute /?
C:\Program Files\Devart\dbForge Data Generator for MySQL>datageneratorsql.com /execute/connection:"Data Source=DBMSSQL\MSSQL2014;Integrated Security=False;User ID=sa"
C:\Program Files\Devart\dbForge Data Generator for MySQL>datagenerator.com /execute/connection:"Data Source=DBMSSQL\MSSQL2014;Integrated Security=False;User ID=sa" /inputfile:"script.sql"
C:\Program Files\Devart\dbForge Data Generator for MySQL>datagenerator.com /execute/connection:"Data Source=DBMSSQL\MSSQL2014;Integrated Security=False;User ID=sa" /inputfile:"script.sql"/Password:mypsw
C:\Program Files\Devart\dbForge Data Generator for MySQL>datagenerator.com /execute/connection:"Data Source=DBMSSQL\MSSQL2014;Integrated Security=False;User ID=sa" /inputfile:"script.sql"/Password:mypsw /quiet
/execute
/connection:"Data Source=DBMSSQL\MSSQL2014;Integrated Security=False;User ID=sa"
/inputfile:"script.sql"
In this case, the command line string will be written as follows:
C:\Program Files\Devart\dbForge Data Generator for MySQL>datagenerator.com /argfile:myarg.txt