The Executor Script is a database tool that allows you to deploy multiple SQL scripts to one or more target servers at the click of a button. Scripts can be deployed directly to the GUI, on the command line, or can be grouped into an executable.
The Executor Script is a database tool that allows you to deploy multiple SQL scripts to one or more target servers at the click of a button. Scripts can be deployed directly to the GUI, on the command line, or can be grouped into an executable.
Overview
Lights
Requirements
Resources
Deploy multiple SQL scripts to multiple servers - Specify the target servers and databases on which you want to run your scripts, specify the scripts you want to run, and order them, map the scripts to the databases, and run them. To make this process even easier, Executor Script performs standard mappings between database groups and script containers on your desktop. The execution process is widely logged and the results and messages are also displayed on the screen. Deploying SQL scripts to the server farm has never been easier.
Generate executable package ready to deploy - Executable Script lets you 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 encrypted credentials) and a small executable that will run all scripts included in the resource file on the target servers/databases.
Organize target databases and scripts into projects - Your target servers/databases can be organized into logical database groups. A database group can contain only databases from the same platform - you cannot put SQL Server databases and MySQL databases in the same group. You can organize your scripts into "script containers" that are analogous to the Windows folder structure, except that script containers are virtual. When you add scripts to a container, you can select individual scripts or identify all files whose name matches a particular pattern in a specific folder. For example: all emp * .sql in the Productsion_Scripts.
Display results in an integrated interface - Displaying the results of a query or even some queries together is one thing, but displaying results from multiple scripts, each of which could potentially contain multiple queries, is a challenge, to say the least. The elegantly designed interface of Script Executor overcomes this challenge by implementing an efficient and intuitive mechanism that allows users to easily navigate hundreds of result sets.
Edit and run individual scripts - Executor Script not only allows you to deal with complex sql script deployment scenarios, but also comes with a complete script editor that lets you modify and run individual scripts as well.
Get a comprehensive deployment report - a comprehensive deployment report provides detailed information about the execution of each script in each target database with a clear visual indicator of script success or failure, plus summary information organized by the target database and by providing scripts with statistical information, as the number of target databases against which a given script was successfully run, the number of databases on which execution failed.
Segment SQL Server, MySQL, DB2, and SQL Server Compact Edition databases into a project - do you have a mixed environment with some SQL Server databases and some MySQL databases? It's not a problem - a single Executor Script deployment project can target all of your databases so that when you want to perform all these maintenance tasks on all databases on different platforms, you can do it in one place with one click - now, that's efficiency.
System requirements:
CPU: 1.8 GHz dual core processor
RAM: 2 GB
HDD / SSD: 50 GB of free space on the main drive
Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit
Resolution: 1024×768
You don't know what software you need or you haven't found what you were looking for? We have a team ready to help you choose the right software for your company.