Deploy SQL Scripts With A Single Click
- Fast parallel execution of multiple SQL scripts
- Error handling settings
- Speeds up database administration tasks
- Execution results browser
- Execute scripts against multiple databases
- Command-line utility included
- Supports multiple databases (native drivers): MySQL, Oracle, PostgreSQL and MS SQL
Datanamic MultiRun MultiDB is a simple tool to quickly execute multiple SQL scripts against multiple databases. The tool supports multiple database platforms. MySQL, Oracle, PostgreSQL and MS SQL are supported.
Define a list of databases, add SQL scripts to execute on these databases and click execute to run those scripts on the databases in the list. The multi-threaded execution of the SQL scripts makes it complete the task fast. After execution of the scripts you can examine the results of the executed scripts on each database in the results browser.
You can control what must be done when an error occurs while executing the SQL scripts: stop executing all scripts, ignore the error and continue, stop executing scripts on the database with the error, ...
This tool is a real time saver. No more annoying repetitive script execution tasks. Datanamic MultiRun MultiDB is an ideal tool for database professionals who need to deploy a bunch of SQL scripts to multiple servers.
Database connectivityExecute scripts on MySQL, Oracle, PostgreSQL and MS SQL Server databases.
Execute multiple SQL scripts against multiple databasesConfigure a list of SQL scripts and run the scripts against a list of databases.
Multi-threaded executionDatanamic MultiRun MultiDB provides a multi-threaded environment for fast execution of the SQL commands.
Cross database version supportYou can execute the same SQL script on databases with a different version number. Your list of databases may contain for example contain MySQL 4 and a MySQL 5 database.
Query results automatically exported to text filesDatabase messages and other command execution output will automatically be saved to text files in a user defined directory.
Very easy to useSimple user interface: Only four tabs (list of databases, list of scripts, execution settings and the results browser) and one button, Execute.
Error handling settingsYou have got full control over what must happen when an error occurs while executing the scripts. You have got four options: Stop executing, Continue executing, Stop executing script on database with error, Stop executing statements after statement with error on database with error, Stop executing any script on database with error.
Project oriented architectureSave the list of databases, the list of SQL scripts, execution settings and execution results.
Define order for script executionExecution order of SQL scripts can be changed manually by moving them up and down in the list of scripts.
Execution results browserYou can easy navigate through the execution results with the results browser. Detailed information is available for every database against which a SQL script is executed.
Combined resultsYou have got the option to add the script execution output to a single file.
Large scripts supportDatanamic MultiRun MultiDB can load and display large SQL scripts without problems.
Unicode support for SQL scriptsHandling of unicode scripts is supported. Datanamic MultiRun MultiDB displays unicode SQL scripts and executes unicode SQL scripts.
Execution progress indicatorA progress indicator for each database is displayed during the execution of the scripts.
Command-line utilityA command-line utility is included. You can create a project with the GUI application and (if desired) execute this project with the command-line utility. This way you can further automate your script deployment.
Datanamic MultiRun MultiDB costs $ 299 for a single user license (EULA).
Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.
Operating System: Windows 10/8.1/8/7/Vista/XP
Memory: 1 GB minimum (2 GB recommended)
Hard Disk: At least 20 MB of free disk space
Databases: Oracle 9i, 10g, 11g, 12 - MS SQL Server 2000, 2005, 2008, 2012, 2014 - MySQL 3,4, 5 - PostgreSQL 7,8, 9