Open and execute large scripts
dbForge Data Compare for MeSQL 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.
Execute large scripts
1. On the Database menu, click 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.
7. Wait for the execution to process.
8. Click Finish to close the wizard.
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
Request a demo
