BlowFrog Software SQL Script™


BlowFrog Software SQL Script is the most comprehensive SQL Server scripting product on the market. Wizard and object explorer interfaces as well as integration into SQL Server Management Studio, provide access the powerful scripting features.
BFS SQL Script
Scripts can be generated to a file, multiple files, clipboard, and query window for:
  • Objects in multiple databases at a time
  • Instance configuration options
  • Instance level objects
  • SQL Server Agent objects

Scripting Options

You are always in control of your scripts. Based on the options that you specify, your scripts will always generate the way you want them, whether scripted from a wizard or the object explorer.

Scripting Options
Click To See Larger Image

You can generate a script to either a query window or the clipboard. You can also generate scripts to files. Many placeholder tags are included to allow you to control the naming conventions on the files. You can also specify generation to a single file or a separate file for each object. Folders for the instance, database, and object type can be automatically generated.

Output Options
Click To See Larger Image

Dependent Objects

Instead of having to track down all of the dependent objects, your scripts are complete and ready to run.

Since all objects are contained within a schema, your schemas are always included within appropriate scripts. However, the scripting engine is smart enough to understand the default schemas that every database will contain such as sys, dbo, and INFORMATION_SCHEMA and will not generate CREATE SCHEMA statements for system objects.

By default, all scripts are generated to ensure that you don’t have to hunt down all of the dependent objects necessary.

For example, if necessary, a CREATE TABLE script will generate with:
  • User defined data types
  • XML Schema collections
  • Partition functions
  • Partition schemes
  • Constraints
  • Indexes – clustered index being generated first
  • XML indexes – primary XML index being generated first
  • Triggers

A script for an indexed view will contain not only the view definition, but also the clustered index created on the view along with a partition function and partition scheme if necessary.

Encrypted Objects

Have you ever lost the source code to an encrypted object or needed to track down performance and contention issues in an encrypted object? BFS SQL Script will allow you to decrypt any of the programmable objects on your instance.

The WITH ENCRYPTION option is a code obfuscation method. SQL Server is not designed to be a digital rights management solution. As such, the WITH ENCRYPTION option utilizes a very simple, publicly available algorithm to obfuscate code.

All of the publicly available algorithms for decryption are slow, cumbersome, one object at a time, and limited to small objects. The decryption engine in BFS SQL Script is extremely efficient, handles multiple objects, and is FAST. One of our testing procedures, which was over 100,000 lines long containing 5MB of code decrypted in under 15 seconds!

SQL Server Agent

BFS SQL Script is the only product that allows you to script all of your SQL Server Agent objects.

While SSMS allows you to script jobs, alerts, and operators – only when SQL Server Agent is started – you can only script these objects one at a time. Have you also noticed that SSMS does not generate a valid script for any job with a job schedule?

BFS SQL Script can script jobs, categories, schedules, alerts, and operators regardless of whether SQL Server Agent is started or not. You can script objects one at a time, script a subset of objects, or script every object. Job scripts with schedules are scripted properly, so you no longer have to deal with scripts that attempt to pass a value to an output parameter.

As of SQL Server 2005, you can re-use schedules. BFS SQL Script allows you to specify whether you want to generate a new schedule for each job or if you want your jobs to reuse an existing schedule with the same parameters.

Instance Level Objects

BFS SQL Script is the only product that lets you script all of your instance level objects such as:

  • Sp_configure options
  • DDL triggers
  • Linked servers
  • Backup devices