You can automate executing the scripts using the command line.
1. Open the Command Prompt.
2. Type a path to the datagenerator.com file located in the Data Generator for SQL Server installation folder on your PC, and then press the SPACE key.
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Generator for SQL Server\datagenerator.com"
3. To execute the corresponding script, use the /execute command, and press the SPACE key.
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Generator for SQL Server\datagenerator.com" /execute /?
4. Specify connection details of the server where to execute the script.
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Generator for SQL Server\datagenerator.com" /execute/connection:"Data Source=DBMSSQL\MSSQL2020;Integrated Security=False;User ID=yourusername"
5. Specify the script file.
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Generator for SQL Server\datagenerator.com" /execute/connection:"Data Source=DBMSSQL\MSSQL2020;Integrated Security=False;User ID=yourusername" /inputfile:"script.sql"
6. Specify the password.
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Generator for SQL Server\datagenerator.com" /execute/connection:"Data Source=DBMSSQL\MSSQL2020;Integrated Security=False;User ID=yourusername" /inputfile:"script.sql"/Password:yourpassword
7. To hide the command line window, use the /quiet command. (Useful for batch files).
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Generator for SQL Server\datagenerator.com" /execute/connection:"Data Source=DBMSSQL\MSSQL2020;Integrated Security=False;User ID=yourusername" /inputfile:"script.sql"/Password:yourpassword /quiet
8. Press ENTER to run the process. If you use the /argfile argument, all the following commands are specified inside an argfile:
/execute
/connection:"Data Source=DBMSSQL\MSSQL2020;Integrated Security=False;User ID=yourusername"
/inputfile:"script.sql"
In this case, the command line string will be written as follows:
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Data Generator for SQL Server\datagenerator.com" /argfile:myarg.txt