Database Deployment Manager (ddm) is an application to create, manage and deploy databases.
The target audience of Database Deployment Manager are database administrators, programmers or hobbyists who want to know more about how to create the startup layout of a database, and learn more about the process itself.
Product's homepage
Here are some key features of "Database Deployment Manager":
· Browse the databases behind the available connections
· Execute queries on the connections' database
· Import tables directly from the database to the solution
· Syntax highlighted SQL editor with code completion
· Connection manager for your databases, so that you don't have to remember them
· Support for reverse engineering and/or creating views
· A Visual Query builder making easier the creation of SELECT queries for views
· Deployment to multible databases (connections) in the same time
· Create and group by type datatypes that can be used to create columns in a table
· Using Object Oriented modelling create table templates which define the structures of a table and then create instances of the table template which is used to physically create the tables in the database
· Create E-R diagrams between chosen tables, export these as graphics or SVG or PDF
· Object oriented / flat modelling of table structures
· Load/Save startup data for tables from CSV files
· Sql Generation for MySQL and injection in a database
· Perform a database reverse engineering to obtain the tables of the database
· Validate an existing solution to pinpoint normalization and other issues that might be sources of errors in the future
Limitations:
· You might need to install the MySQL client libraries, in case it's not working.
· Some Linuxes come with these installed by default, others not.
What's New in This Release: [ read full changelog ]
· This release has many bugfixes, support for stored procedures, and data validation for the table instances.