MS SQL Database (Run scripts)

Navigate to: Main Menu > MS SQL > Databases > Select a database > Click the Run scripts tab.

This section allows you to execute Transact-SQL (T-SQL) commands against your database directly from the browser. This is useful for seeding data, creating tables, or running maintenance tasks without connecting via a local client like SSMS.

Execution Methods

Choose the method that best fits the size and location of your script:

1. FROM BACKUP LOCATION (Recommended for Large Scripts)

Use this option if you have already uploaded your .sql file to the server using the Backup file manager or FTP.

• Workflow: Select the file from the dropdown list and click EXECUTE.
• Benefit: Since the file is already on the server, this method eliminates upload timeouts during execution. It is the only reliable way to run scripts larger than 100MB.

2. FROM YOUR COMPUTER

Use this for quick, one-time execution of smaller local files.

• Workflow: Click BROWSE or drag-and-drop a .sql file from your desktop. The system will upload and execute it immediately.
• Limitation: The maximum file size is 100 MB.

3. OPEN T-SQL CONSOLE

Click this link to open a new browser window where you can type or paste SQL code manually.

• Usage: Ideal for running short ad-hoc queries (e.g., SELECT * FROM Users) or quick maintenance commands (e.g., UPDATE or DELETE).
• Modes: The console automatically handles both simple queries (which display a results grid) and batch commands (which perform actions without returning data).