Opening and executing large scripts

dbForge Query Builder for SQL Server allows you to execute large scripts without opening SQL Editor and loading the whole script in memory. When you try to open a large script, you will be prompted to execute it using Execute Script Wizard.

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

If script size exceeds 10 Mb, the SQL syntax highlight is disabled. It is not enabled when you reduce the script in the editor. You should reopen the script to re-enable the feature.

Note

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

Executing large scripts

To execute a large script:

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

Execute Large Script

2. In the Connection field, select a connection to a required database server against which you want to execute your script.

3. In the Database field, select a required database from the drop-down list.

4. In the SQL File name field, specify the path to the script you want to execute.

5. In SQL file encoding, ensure that the file encoding is selected correctly. The program automatically selects it based on the script. If it fails, the default encoding (the current Windows encoding on the machine where the program is running) is selected. You can always select a required encoding from the drop-down list box.

6. Click Execute to run the script.

Execute Script Wizard

7. Wait for the execution to process.

Execution Progress

8. Click Finish to close the wizard.

Operation Complete

Note

In case of any errors, you will be notified accordingly. The wizard will display the number of occurred errors. By selecting Open script you will open the source file after the wizard is closed.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Query Builder for SQL Server.
Request a demo

Request a demo

If you consider employing the Query Builder for your business, request a demo to see it in action.
Ready to start using dbForge Query Builder for SQL Server?