Quick and Efficient Execution of SQL Queries & Scripts in Multiple Oracle Databases!!

Well today we will focus on another great FREE tool that has made the life of database administrators easy. MuSQL is a free database tool by BSUtils. It can be used on Windows 2000/XP/2003 Server/Vista. The size of MuSQL is only 138.27K.

Most database administrators have to deal simultaneously with many databases containing similar tables or entire schemas. These databases may be in different environments, locations, versions, etc. You may have to run identical queries against these databases, compare the query results or modify the data. Some of them are scheduled to run periodically. Still, there is always a need to run one-time unscheduled jobs.

Say, you found that the data file for SYSTEM tablespace is not on Autoextend in one database. What is it in all other databases? Or you need to drop or lock a personal account after the user has left - everywhere. Or to verify if a schema for a DBA tool has been created - everywhere. Or run a report for the Audit department - again, everywhere. This is exactly where MuSQL excels.

MuSQL allows DBAs and users to simultaneously and quickly execute their SQL queries and 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. Version 2.52 is a bug fixing release.

MuSQL is currently FREE so do not waste time and download it now!