Automate data generation script execution

Last modified: June 22, 2025

Automating the execution of data generation scripts allows you to streamline your workflows and run tasks without manual intervention. By using the command-line interface (CLI) in dbForge Studio, you can schedule or execute scripts automatically, making it easier to integrate data generation into batch processes or automation systems.

Execute the script automatically

1. Start Windows Command Prompt (CMD).

Note

To run the 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 desktop mode, press the Windows + R keys, to show the Run command line.

In the window that opens, type cmd and press Enter.

2. Type a path to the dbforgepostgresql.com file located in the dbForge Studio for PostgreSQL installation folder on your PC, and then press the SPACE key.

C:\Program Files\Devart\dbForge Studio for PostgreSQL\dbforgepostgresql.com

3. To execute the script, use the /execute command, and then press the SPACE key.

C:\Program Files\Devart\dbForge Studio for PostgreSQL>dbforgepostgresql.com /execute /?

4. Specify the connection details of the server on which you want to execute the script.

C:\Program Files\Devart\dbForge Studio for PostgreSQL>dbforgepostgresql.com /execute/connection:"User Id=yourusername;Host=host_name;Port=port_number;Database=database_name;Unicode=True;Connection Timeout=connect_timeout;Integrated Security=False"

5. Specify the script file.

C:\Program Files\Devart\dbForge Studio for PostgreSQL>dbforgepostgresql.com /execute/connection:"User Id=yourusername;Host=host_name;Port=port_number;Database=database_name;Unicode=True;Connection Timeout=connect_timeout;Integrated Security=False" /inputfile:"script_filename.sql"

6. Specify the password.

C:\Program Files\Devart\dbForge Studio for PostgreSQL>dbforgepostgresql.com /execute/connection:"User Id=yourusername;Host=host_name;Port=port_number;Database=database_name;Unicode=True;Connection Timeout=connect_timeout;Integrated Security=False" /inputfile:"script_filename.sql"/Password:yourpassword

7. To hide the command-line window, use the /quiet command. (Useful for batch files).

C:\Program Files\Devart\dbForge Studio for PostgreSQL>dbforgepostgresql.com /execute/connection:"User Id=yourusername;Host=host_name;Port=port_number;Database=database_name;Unicode=True;Connection Timeout=connect_timeout;Integrated Security=False" /inputfile:"script_filename.sql"/Password:yourpassword /quiet