This software simplifies database management for DBAs by allowing them to handle multiple DBMS instances using an easy-to-use GUI. It is particularly useful for organizations with multiple DBMS installations that are not well integrated.
This software is a valuable tool for Database Administrators (DBAs) as it enables them to manage multiple DBMS instances simultaneously using a convenient GUI to define nodes and database groups. It is especially useful for organizations with weakly-integrated DBMS installations from unrelated application vendors. The program currently supports the most popular enterprise databases: Microsoft SQL Server and IBM DB2 UDB. However, if a significant number of users show interest in other DBMS vendors, such as PostgreSQL, Oracle, and MySQL, the software can add support for those too.
The current version and edition of ADBM is available free of charge, with the only limitation being the duration of the license term, which is six months. After this period, users can download the new version from the software's website and continue using it. The light edition of the product will always be free, although it will not come with personal support.
The main software interface features four windows: Nodes, Database Groups, Database, and Commands. In the Nodes window, users can specify DBMS servers and their parameters, including hostname, instance name, username, and password. For Database Groups, users can simply specify group names to be used later for executing operations on a group of databases. In the Database window, users can specify the database name, the node on which it exists, and to which groups it belongs. Here, users can mark several groups. Finally, the Commands window allows users to specify customized commands to be run against a group or a single database. Command specifications include the command name, SQL code, and tokens such as Database and Table if executed for a set of tables defined by a RegEx. Commands can be run from GUI by right-clicking on a row in the Databases or Database Groups window or run from a command line to automate repeated tasks or operate them by external scheduling.
Overall, ADBM provides an excellent solution for managing multiple DBMS instances using an intuitive, easy-to-use interface with customizable commands for automated repeated tasks. Additionally, the software is free of charge for the current version and edition, making it an attractive option for small organizations or individual users managing multiple databases.
The current version and edition of ADBM is available free of charge, with the only limitation being the duration of the license term, which is six months. After this period, users can download the new version from the software's website and continue using it. The light edition of the product will always be free, although it will not come with personal support.
The main software interface features four windows: Nodes, Database Groups, Database, and Commands. In the Nodes window, users can specify DBMS servers and their parameters, including hostname, instance name, username, and password. For Database Groups, users can simply specify group names to be used later for executing operations on a group of databases. In the Database window, users can specify the database name, the node on which it exists, and to which groups it belongs. Here, users can mark several groups. Finally, the Commands window allows users to specify customized commands to be run against a group or a single database. Command specifications include the command name, SQL code, and tokens such as Database and Table if executed for a set of tables defined by a RegEx. Commands can be run from GUI by right-clicking on a row in the Databases or Database Groups window or run from a command line to automate repeated tasks or operate them by external scheduling.
Overall, ADBM provides an excellent solution for managing multiple DBMS instances using an intuitive, easy-to-use interface with customizable commands for automated repeated tasks. Additionally, the software is free of charge for the current version and edition, making it an attractive option for small organizations or individual users managing multiple databases.
What's New
Version 2014:
This a public release
New convenient installer
Sample scripts and configurations