Executing Large Scripts
dbForge Studio allows you to execute large scripts without opening them in the 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 help of the Execute Script Wizard.
To execute a large script, do the following:
- To open the Execute Script Wizard, go to the Database menu, and click
Execute Large Script. - Click the Connection field to select a connection to a required database server against which you want to execute your script. In the drop-down list of the field, you can click the Manage link to open the Connection Manager dialog. It will help you to create a connection if necessary.
- Click the Database drop-down list to select a required from the list of those databases that are available on the selected database server.
- In the File name field, specify the path to the script you want to execute.
- In the SQL file encoding field, check 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.
- Click Execute to execute the script.
Tip: See all script execution messages in the Output window.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
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 MySQL?