EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Managing scripts


Script files stored locally on the server can be easily accessed from the DB Explorer within the Scripts branch.

 

 

DB Explorer - Managing scripts

 

 

To create new script right-click the appropriate branch in the DB Explorer tree and select the iconNewScript New Script item. You will be asked for the script name. When the name is assigned the script appears in the DB Explorer tree and the SQL Script Editor is opened.

 

Local Script - Setting script name

 

 

If a script is created in SQL Script editor and saved to the default folder, it will appear in the DB Explorer tree automatically.

 

 

It is also possible to create subfolders in the Scripts branch by selecting the New script folder context menu item. Folders created there are created physically as subfolders to the folder assigned as default for local scripts in the DB Registration info | Directories.

 

To change directory where local scripts to be stored use the Select Directory item of the Scripts context menu, or use the respective field of the DB Registration info | Directories dialog. If specified folder already contains scripts, these scripts will be added to the DBExplorer tree.

 

Using the context menu of a script you can:

iconOpenScript - open the script in the SQL Script Editor,

rename the script,

iconDropScript - drop the script.

 

 


See also:

SQL Script Editor

Database Explorer

Database Registration Info