How to execute large SQL scripts in dbForge Studio for SQL Server
dbForge Studio 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 with the help of the Execute Script Wizard.
To execute a large script:
- On the Database menu, click Execute Large Script.
- In Connection, select a connection to a required database server against which you want to execute your script.
- In Database, select a required database from the drop-down list.
- In File name, specify the path to the script you want to execute.
- In SQL file encoding, ensure that the file encoding is selected correctly. The program automatically selects it basing 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.
- Click Execute to execute the script.
Open large scripts in SQL Editor
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 script to re-enable the feature.
Note
The maximum file size the application can open depends on available memory on your computer.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?