DBLense Script Runner — Complete User Guide

Execute SQL scripts across multiple servers and databases in one click. Run scripts sequentially, in parallel, or in batches — then export results to Excel or CSV. All from a single portable .exe.

Getting Started

1. Create a Server Group — Click ＋ in the Server Groups toolbar. Enter a name like "Production" or "Dev/Test".
2. Add Servers — Click ＋ Add Server. Enter your server details and test the connection.
3. Load Databases — Select target servers, then click Load Databases.
4. Write or Load a Script — Type SQL in the editor tab, or switch to Script Folder tab.
5. Execute — Click ▶ Execute and watch results stream in.

Server Group Management

Creating Groups

Groups are organizational containers — create groups like "Production Servers", "Staging", "Azure SQL", or "DR Cluster".

Adding Servers

Click Test Connection to verify connectivity before saving.

Selection Controls

• Checkboxes on groups and servers control which targets are included
• Checking a group toggles all servers within it
• ☑ Select All / ☐ Deselect All buttons apply to all groups

Authentication Modes

Passwords are encrypted using Windows DPAPI — they are never saved as plain text.

Script Editor

Type or paste SQL directly into the built-in editor with:

• Multi-line input with Tab key support
• Monospace font (Cascadia Code / Consolas)
• Horizontal and vertical scrolling

Script Folder

Run multiple .sql files from a folder:

1. Click Browse... and select a folder
2. All .sql files are listed with checkboxes, filename, and file size
3. Use Select All / Deselect All to toggle
4. Scripts are listed alphabetically (top-level only, no subfolder recursion)

Target Databases

After selecting servers, click Load Databases. Three quick filters:

If no databases are loaded for a server, execution falls back to the master database.

Execution Modes

Error Handling

GO Batch Splitting

• Scripts are split on standalone GO lines (case-insensitive)
• GO with repeat count: GO 5 runs the preceding batch 5 times
• GO inside string literals, block comments, and line comments is correctly ignored
• False positives like GOTO or GOPHER are not treated as separators
• Empty batches are automatically skipped
• Each batch has a 300-second timeout

Results

Script Results Tab

All result rows merged into a single data grid with two auto-prepended columns: Instance Name and Database Name. Supports sorting and column resizing.

Execution Summary Tab

Execution Log Tab

Timestamped, auto-scrolling log with 🔵 Info, ✅ Success, ❌ Error, and 🛑 Stop messages.

Exporting Results

Excel Export

• Professional formatting: dark blue headers, alternating row shading, auto-sized columns
• Color-coded status (green = success, red = failure)
• Sheet modes: Single Sheet, Sheet Per Group, Sheet Per Server, Sheet Per Database
• Every file includes an Execution Summary sheet

CSV Export

UTF-8 CSV with proper escaping. Data rows followed by an Execution Summary section.

Practical Workflows

Quick Ad-Hoc Query Across All Servers

1. Check all server groups → Load Databases → Select User databases
2. Type query in Script Editor
3. Set Execution Mode to Parallel
4. Execute → Export to Excel (Single Sheet)

Run Migration Scripts in Order

1. Create folder with sequentially named scripts (001_AddColumn.sql, 002_UpdateData.sql)
2. Script Folder tab → Browse → Select scripts
3. Set Sequential mode + Stop on Error
4. Execute

Security Compliance Check

1. Place compliance scripts in a folder
2. Select all servers and databases
3. Run with Sequential + Continue on Error
4. Export to Excel for review

Data Storage & Security

System Requirements