- Quick specs
- Price: Free
- Operating system: Windows XP, Windows 2000, Windows 98
- Date added: February 10, 2008
- Total Downloads: 255
- Downloads last week: 1
- See full specifications
A newer version of MuSQL is available.
(Download doesn't provide access to previous versions of this program.)
- Average user rating: stars out of 1 votes
See all user reviews
Publisher's description
From BSUtils :MuSQL is designed to simultaneously execute your SQL queries, statements, and scripts in multiple Oracle databases quickly and effortlessly.
Why would you want to run the same SQL statement in several databases?
Sometimes, a database user may have to deal with many databases that contain similar tables or entire schemas - in different environments, locations, versions, etc. That makes running identical queries or DML statements against these databases possible and useful - query results may be compared, or data may be quickly modified in a similar way.
However, it is database administrators who can benefit the most from MuSQL. The SQL queries and scripts they run are in most cases identical for all databases. 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. Ability to simultaneously and quickly execute queries and scripts in multiple databases dramatically increases your efficiency and opens opportunities you never had before. (Oracle Grid provides a limited ability to execute a single SQL statement - not a multi-line script - in multiple databases, but it has to be installed and configured on all database servers.)
Come up with a query or SQL 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. Want to save the output from all databases to one file? You got it. Want to run it again and save to another file? No problem. Send output from each database to a separate file? Save the script, database selection, and all other options for a later use? Save a default database selection and user ID so that next time you do not have to specify them? All these and other features are available to help you be most efficient with MuSQL and your databases.
What's new in this version:
- Nested database groups
- Export and import of jobs and database groups
More popular Database Management Software downloads
- 1,267 downloads 1. Microsoft Office Access 2007
- 400 downloads 2. Oracle 9i Database Enterprise Edition
- 394 downloads 3. DBF Viewer 2000
- 342 downloads 4. DBF Manager
- 339 downloads 5. School Management System
- See all Database Management Software downloads
User reviews of MuSQL 2.60
Write your own review Be the first one to review MuSQL 2.60 and share your experience with the CNET community!
Previous versions: See all user reviews
Submit your review
Previous Versions:
