SQL Server Scriptor utility

Overview

SQL Scriptor is a utility that performs scripting SQL Server objects into multiple files.

Main features of the utility include:

• objects are split into separate folders (tables, views, stored procedures, etc)
• you can select objects you want to include (or exclude) from scripting
• your database scripting configuration is preserved between sessions
• Use ALTER option creates scripts in IF NOT EXISTS .. CREATE .. ALTER pattern

Getting Started

Installing SQL Scriptor is easy. You can dowload installation files zipped in SqlScriptor_Setup.zip, unzip them to a temporary folder.

Then run Setup.exe file and after a few clicks the installation is complete (it may ask to install .Net framework, if not installed already). You will see a new icon added to your desktop and start menu.

(You can download executables only here.)

Running the program will bring up the following screen:

As any .Net application the utility will take its time to load for the first time.

Type in the server name of click "Refresh" button to auto-populate server list.

Select "Authentication" method - when SQL Server option is selected, you can tick "Remember" checkbox - this will save encrypted password for later retrieval.

Type in the database name or click "Refresh" button to auto-populate database list.

Clicking on "Script" button will start creating files in the corresponding folders (utility will display currently processed object in a label just above "Open Script Folder button").

You can cancel processing if you want to change conditions.

Selecting Scripting Options

Clicking on "General" button in Scripting Options will bring up the screen where you can set general scripting options:

Clicking on "Tables / Views" button in Scripting Options will bring up the screen where you can set tables and/or views scripting options:

Selecting Scripting Objects.

Clicking on   button will bring up the list of database objects:

In the image above some of the tables are not included in the list.

Depending on the size of the objects list, it might make sense to save only exclusions rather than objects to script.
Note: if all or none of the objects selected, then the value of the checkbox in the main screen determines whether to script all objects of the selected type.

Technical Details.

SQL Scriptor only supports SQL Server database versions 2000, 2005 and 2008 (R2). It uses Microsoft SMO libraries to enumerate and script database objects.

Utility saves user settings in the configuration file located in LocalApplicationData folder.

Known limitations:

• Utility only scripts objects that are available for selection on the main screen.
• Table data is not available for scripting
• CLR objects (assemblies) source code is not scripted.

The utility comes as a stand-alone executable built using .Net technology, and therefore requires .Net runtime to be installed in order to run.

Support

Please forward all your questions, comments or suggestions to support@compros.com.au.

Version updates:

·  18 Sep 2011:   Added "Use ALTER" and script synonyms functionality.
·  02 Mar 2010:   Added functionality to script triggers into separate folder.
·  20 Dec 2009:   Initial version made available to public.