Oracle connectivityDirect access to Oracle databases (no Oracle client software required). Oracle version 9,10 and 11 are supported.
Execute multiple SQL scripts against multiple databasesConfigure a list of SQL scripts and run the scripts against a list of Oracle databases.
Multi-threaded executionDatanamic MultiRun for Oracle provides a multi-threaded environment for fast execution of the SQL commands.
Cross database version supportYou can execute the same SQL script on Oracle databases with a different version number. Your list of databases may contain for example contain Oracle 10 and a Oracle 11 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 can load and display large SQL scripts without problems.
Unicode support for SQL scriptsHandling of unicode scripts is supported. Datanamic MultiRun 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.
Try it out: