How to Run SQL Scripts

The control panel provides flexible tools to execute SQL commands against your database. You can run simple queries interactively using the console, or execute large T-SQL script files for deployment and maintenance.

Accessing the Tools

To access the script execution tools:

1. Navigate to the MS SQL section in the main menu.
2. Click on the specific database you wish to manage.
3. Select the Run scripts tab.

Option 1: Open T-SQL Console (Interactive)

This option is best for running short queries, checking table data, or applying quick fixes.

• Click the OPEN T-SQL CONSOLE button.
• This will open a new browser tab.
• Type or paste your SQL query or T-SQL batch into the text area.
• Click the EXECUTE T-SQL button to run the command and view results immediately.

Option 2: Upload and Run (From Your Computer)

Use this method to execute a script file stored on your local machine.

• Click the From your computer (or "Upload and run") link.
• Browse for your file or drag and drop it into the upload area.
• Requirements:
  • The file must have a .sql extension.
  • The file size must not exceed 100MB.
• Click EXECUTE to upload and run the script.

Option 3: Run from Backup Location

Use this method if you have a large script file that you have already uploaded to the server via FTP.

• Click the From backup location link.
• Select the folder (usually root) and the specific .sql file from the list.
• Click EXECUTE to run the script.