SQLScripter

SQLScripter is a utility that scripts SQL Server databases, jobs,  logins and any other sql server object. The utility is designed to  automate the process of schema generation.

SQLScripter is a powerful command line utility that scripts SQL Server objects. The utility is designed to automate the process of schema generation.

SQLScripter scripts your entire server(s). Schedule an automatic job that scripts all database level objects and server level objects on a daily or weekly basis.

SQLScripter offers flexible configuration options meeting various needs. You can script all your production servers from a single location while nothing is installed on any SQL Server instance.

SQLScripter can script all objects of the same type to a single file, i.e. a single file containing all tables, a single files containing all Views and so on, or script every object to it’s own file which is useful when you develop your database under source control and need to check out and check in files.

Oooops… a problem found in a stored procedure loaded in the recent version – no need to look for the appropriate backup and restore. Save that time and immediately get the required object available on your file system.

Your developers access the production servers to see if the schema matches the schema at their environment – not any more, automate a job that brings the production schema to your organization and save your developers and your organization a lot of precious time.

Besides the ability to script all objects there are many command line switches that are helpful in the DBA”s daily tasks, for example while tuning indexes the I switch will generate indexes script files useful for backup purposes. Similarly the FK switch will generate a script file contains the CREATE statements for all Foreign Key Constraints. This can be done for a single database, a few databases or all databases on the server, or for all servers defined in the configuration file. In the same way the TR switch will script triggers. DBAs working with Replication may find the NFR (NOT FOR REPLICATION) switch useful.

SQLScripter can be useful in High Availability scenarios where you need to assure that objects belonging to a specific server are always available and exists on another server when a disaster event occurs.

Many High Availability solutions do not take care of server level objects (jobs, logins, linked servers etc) and SQLScripter well addresses this requirement.

SQLScripter is a professional tool at a low cost price.

Installation and configuration is quick. The product is very light and when you install it you do not effect anything on your machine.

Obtain a license

  1. Purchase a license by clicking the PayPal button
  2. Email the ComputerName.tek file (located at your working folder) to support@sqlserverutilities.com
  3. Receive a reply mail containing the license file
  4. Locate the received license file at your working folder. The working folder is the folder where SQLScripter is installed. 

Your license is for life and includes support and updates with no additional fee.

 

Swipe to the left or right to view more details

Features Standalone Standard Enterprise
$99
$199
$299
Number of servers that can be scripted
1
4
Unlimited

Script unlimited number of databases
The number of databases that can be scripted on a single SQL Server instance

Script all database level objects
Script tables, views, functions, stored procedures, triggers etc

Script all server level objects
Script Jobs, Linked Servers, Logins, DDL Server Triggers etc

Zip the Output folder
Compress the Output folder generated at the end of each run

Password protection on the zipped Output folder
Secure the output by a password

Clean up the Output folder
A clean up task that deletes files older than a predefined number of days

Support all available command line switches

Prerequisites

SQLScripter requires Microsoft .NET Framework version 3.5 installed on the machine where the program is installed (if required a version based on .NET 2 is available).

 

Installation

Run SQLScripter.msi file to install the program.
Following the installation edit SQLScripter.exe.config file and Servers.config file.
Once the two files have been configured you can launch the program by running SQLScripter.exe file.

Supported operating systems

Windows Server 2008
Windows Server 2012

Windows Server 2016

Windows Server 2019
Windows XP
Windows 7
Windows 8

Windows 10

Comments

SQLScripter terminates with a return value of 0 on success and 1 on failure.
SQLScripter does not script encrypted routines.

Usage

There is one configuration file to edit before running SQLScripter:
SQLScripter.exe.config (see the bellow table for details)
SQLScripter.exe.config is where you define all the configuration settings required.

Log File

There are various settings that if required can be modified by editing the file log4net.config.
The key “file” represents the logs file location and defaults to the working directory.

The key “maxSizeRollBackups” defaults to 5 which represent the maximum number of log files that are available at a given time. The files are managed in a FIFO (First In First Out) algorithm.
The key “maximumFileSize” defaults to 10 which represent a size of 10MB per log file.

Support

When applying for support please send a description of the problem encountered to support@sqlserverutilities.com with SQLScripter in the subject of the mail and attach the following files:
SQLScripter.exe.config
Servers.config
SQLScripter.log

The following two tabs change content below.
Yaniv Etrogi is an SQL Server consultant. He loves SQL Server and he is passionate about Performance Tuning, Automation and Monitoring.