MuSQL allows DBAs and users to simultaneously and quickly execute their SQL queries and SQL*Plus scripts in multiple Oracle databases. It dramatically increases
MuSQL allows DBAs and users to simultaneously and quickly execute their SQL queries and SQL*Plus scripts in multiple Oracle databases. It dramatically increases efficiency and opens opportunities you didn't have before. Come up with a query or script, specify the databases in which you want to run it, a user ID and password, and MuSQL will log on to each database and run your script. MuSQL is installed on and connects to databases from a Windows machine using Oracle Net and Oracle Database client. Jobs and reports (output) can be saved and reopened later. MuSQL is highly configurable. It also allows command-line non-interactive execution suitable for scheduling. MuSQL is most useful and effective when account passwords are the same (synchronized) in all databases. To keep periodically expiring passwords synchronized use PassAid, another tool from BSUtils.com.
What's new in this version:
Version 2.79:<ul><li>Installing and running MuSQL on Windows 10 machines is fully supported</li><li>Configuring MuSQL jobs to connect to databases AS SYSASM, AS SYSBACKUP, AS SYSDG, or AS SYSKM is now supported (the last 3 connection modes are available beginning with Oracle Database 12c and require a corresponding version of Oracle Database client)</li><li>After the job script has executed in the last of the selected databases, the Try & Ask dialog asking user whether the script ran as exp... See all new features »
Operating systems:
Windows 7, Windows Vista, Windows XP, Windows 2003, Windows 2000, Windows Server 2008
Additional requirements:
Oracle Database client
Date:
03.02.2017
Related Software