This product helps DBAs to manage many DBMS instances at once using convenient GUI to define nodes, database groups.
It can be especially useful for organizations having multiple weakly integrated DBMS installations when solutions are brought from many unrelated application vendors.
Right now the program supports the most popular enterprise databases: Microsoft SQL Server and IBM DB2 UDB
If considerable amount of users indicate their interest in other DBMS vendors, we can add support for any DBMS you require. For example we can add PostgreSQL, Oracle, MySQL, etc.
Current version and edition of the ADBM is free of charge and the only limitation is duration of license term which is 6 months after which you need to download new version from our website and continue to use the product. Light edition of the product will be FREE forever (without personal support).
On below screenshot you can see there are main four windows to define the databases and corresponding servers:
Nodes Here you can specify DBMS servers and their parameters: hostname, instance name, username and password
Database groups Just specify group names. You can use it later for executing operations on a group of databases.
Database Here you specify database name, on which node it exists and to which groups it belongs. You can mark several groups here.
Commands In commands window specify customized commands to be run against a group or a single database. Command specification includes command name, SQL code with tokens like Database and Table if executed for set of tables defined by a RegEx, etc. Commands can be run from GUI by right clicking a row in Databases or Database Groups window and also can be run from a command line to automate repeated tasks or run them by external schedule.
ModelRight - Do you need to design, visualize or document your database? ModelRight 3 can reverse engineer your existing database to get a graphical view of it, generate all the SQL statements to create the... ...