Scripting Wizard

WinSQL’s scripting wizard allows users to select and execute multiple DML (INSERT, UPDATE, DELETE) or DDL (CREATE TABLE/VIEW/PROCEDURE) queries at one time, rather than executing them individually—an often time-consuming process.

Important Note: Do not run SELECT queries using the Scripting Wizard.

Perform the following steps to use the Scripting Wizard:

1Start WinSQL Professional and connect to the desired database.

2From the Tools menu, click Scripting Wizard. A window similar to the following displays:

1Click Add files to navigate to and select the SQL script(s) you wish to run.

2Click Execute to run the script(s).

The Script Execution Wizard window provides information about the execution status of the running scripts, along with information about successful and unsuccessful query runs. This information is also written to a log file that can be saved and/or viewed using a standard text reader.