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 is new in this release:
Version 2.79:
- Installing and running MuSQL on Windows 10 machines is fully supported
- 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)
- After the job script has executed in the last of the selected databases, the Try & Ask dialog asking user whether the script ran as expected is not presented anymore
What is new in version 2.78:
- When SQL*Plus global profile glogin.sql produces output, the application does not crash when user enters a password
- A tip offered on how to remove "Administrator:" from window title
- new application icon fully supports Windows 7 and 8
- bug fixes
Requirements:
Oracle Database client
Comments not found