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.
|
|