xSQL Script Executor

Script Executor is a professional grade database tool that allows you to deploy multiple Sql scripts on one or more target servers with a click of a button. Scripts can be deployed directly from the GUI, from the command line or they can be wrapped into an executable.

Script Executor supports SQL Server 2012/2008R2/2008/2005/2000, MySQL 5.0/5.1, DB2 9.0 and SQL Server Compact Edition 3.5.

Highlights


  • Deploy multiple Sql scripts on multiple servers
  • Generate ready to deploy executable package
  • Organize target databases and scripts in projects
  • View results in one integrated interface
  • Edit and execute individual scripts
  • Get a comprehensive deployment report
  • Target SQL Server, MySQL, DB2 and SQL CE in one project

Requirements


  • Microsoft .NET framework 2.0
  • SQL Server Compact 3.5 runtime in order to execute scripts against Sql Server Compact
  • IBM DB2 connector for .NET in order to execute scripts against DB2 databases

Version Information


    Major Version
  • Version Number: 3.0
  • Release Date: February 24, 2009
    Current Version
  • Version Number: 3.6.0.0
  • Release Date: April 29, 2013

Features


Deploy multiple Sql scripts on multiple servers - specify the target servers and databases on which you wish to execute your scripts, specify the scripts you wish to execute and order them, map the scripts to the databases and execute. To make this process even easier Script Executor performs a default mappings between database groups and script containers on your workspace. The execution process is extensively logged and results and messages are also displayed on the screen. Deploying Sql scripts to your server farm has never been easier.

Generate ready to deploy executable package - Script Executor allows you to generate a ready to deploy executable from a configured deployment package. The executable package consists of a resource file that contains the compressed deployment package (scripts, databases, mapping between them and the encrypted credentials) and a small executable that will execute all the scripts included in the resource file against the target servers/databases.

Organize target databases and scripts in projects - your target servers/databases can be organized in logical database groups. A database group can only contain databases of the same platform - you can not put SQL Server databases and MySQL databases in the same group. You can organize your scripts into "script containers" that are analogus to the folder structure in Windows except that script containers are virtual. When you add scripts in a container you can select individual scripts or you can identify all the files the name of which matches a certain pattern under a particular folder. For example: all emp*.sql under the Productsion_Scripts folder. Once you have have organized the databases and scripts and you have mapped them together you can save the project so that next time you need to deploy those same scripts against the same target databases you can simply open the project and click execute.

View results in one integrated interface - Displaying the results of a query or even a few queries together is one thing but displaying results of multiple scripts each of which could potentially contain multiple queries is a challenge to say the least. Script Executor's elegantly desinged interface overcomes this challenge implementing an efficient and intuitive mechanism that allows the users to browse through potentially hundreds of results sets with ease.

Edit and execute individual scripts - not only does Script Executor allow you to handle complex sql script deployment scenarios but it also comes with a full featured script editor that allows you to modify and execute individual scripts as well.

Get a comprehensive deployment report - a comprehensive deployment report provides both detailed information about the execution of each script against each target database with a clear visual indicator of the success or failure of the script as well as summary information organized by target database and by script providing statistical information such as the number of the target databases a given script executed successfully against, the number of the databases on which the execution failed etc.

Target SQL Server, MySQL, DB2 and SQL Server Compact Edition databases in one project - you have a mixed environment with some SQL Server databases and some MySQL databases? Not a problem - a single Script Executor deployment project can target all your databases so that when you want to execute all those maintenance tasks against all those databases in different platforms you can do it from one place, with one click - now, that is efficiency.

Pricing
Starting from: $249
Order
Best Value
Consider Silver Subscription instead. It contains:
Order
Related Products
You might be interested in the these products:
Additional Information
Testimonials
  • Script Executor has been an integral part of our production release process. It's easy to use and has performed reliably and consistently for dozens of releases. Recommended.
    Eric T.
    ZeroChaos, FL
  • You guys are FAST! Fantastic support! I'm not even a customer yet!
    Matt N.
    Brandes Investment Partners & Co.
  • Hats off to you guys for creating some awesome tools...
    Glenn P.
    Armga Integrated Systems, Inc.
  • I think your support is the best. It is the reason I am buying your products.
    Annette W.
    Planimetron Inc.