Open and execute large scripts

Data Compare 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.

To execute a large script:

1. In the Database menu, click Execute Large Script. The wizard opens.

Execute Script Wizard

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.

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 Data Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Data Compare in less than 5 minutes.
Request a demo

Request a demo

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