Execute large SQL scripts

dbForge Studio can execute large scripts without opening SQL Editor or loading the entire script into memory. When you try to open a large script, you are prompted to run it using the Execute Script wizard.

Execute a large script

1. On the Database menu, select Execute Large Script.

2. In Connection, select the database server connection to run the script against.

3. In Database, select the target database from the drop-down list.

4. In File name, specify the path to the script file.

5. In SQL file encoding, verify the correct encoding is selected.

Tip

dbForge Studio detects the encoding automatically based on the script. If detection fails, the default encoding is used (the current Windows encoding on the computer). You can manually select a different encoding from the list.

6. Click Execute.

Open large scripts in SQL Editor

To avoid performance issues, some features are disabled when working with large SQL scripts.

If a script is larger than 10 MB, SQL syntax highlighting is disabled. Reducing the script size in the editor does not re-enable highlighting—you must reopen the script for it to take effect.

Note

The maximum file size the application can open depends on the available memory on your computer.