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.