Database Deployment Manager
 Database Deployment Manager 0.1f | |
| Developer(s) | The Unauthorized Frog project |
|---|---|
| Stable release | 0.1k
/ 2013-09-26 |
| Engine | |
| Operating system | Windows 2000, Windows XP, Windows 7 and Windows Vista, Linux |
| Type | Database Design, Data Modeling |
| License | LGPL |
| Website | sourceforge |
Search Database Deployment Manager on Amazon.
Database Deployment Manager (DDM) is an open-source desktop-oriented multi-platform database design tool that allows database administrators and/or programmers to create database structures (using an object-oriented methodology) and deploy them into an existing database. The tool allows creation of diagrams to identify basic relations between the defined structures. It is written in C++\Qt[1] and distributed as free software under the LGPL License.[2]
Database support
DDM currently works with[3]
Plans are to extend it to be able to use more databases.
Features
- Create data-types that can be used to create columns in a table
- Management of database tables and views
- Using object-oriented modeling, 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
- Object-oriented / flat modeling of table structures
- Load/Save startup data for tables from CSV files
- Database design validation
- SQL script generation for a target database engine and parallel deployment into chosen databases
- Unique visual query builder
- Browsing an existing database and importing tables into the solution
- Version management and track changes of database tables
- Documentation generator
- Reverse engineer a database
Object Oriented Modeling
This feature allows the creation of database tables following the paradigms of object oriented programming. You can have a base table (called a table template), and you can derive (specialize) tables from it. The specialized table will have the columns inherited from the base table, and you can also add new columns to it. The table instances can be populated with default values, and after population they are deployed in the selected database(s). There can be more instances of a table template, each of them can have its own set of default values.
DDM uses a building block approach; all the columns of a table are based on generic data types which are mapped to SQL types of the underlying database. This offers a high grade of re-usability and flexibility when designing a database, and will also make easier the future mapping of data types to more common programming language types.
License
DDM 0.1j is released under LGPL
See also
References
- ↑ "Database Deployment Manager". SourceForge. Retrieved 2018-06-02.
- ↑ "Database Deployment Manager in Launchpad". launchpad.net. Retrieved 2018-06-02.
- ↑ "Features". Database Deployment Manager. Retrieved 2018-06-02.
External links
 |
Wikimedia Commons has media related to [[commons:Lua error in Module:WikidataIB at line 466: attempt to index field 'wikibase' (a nil value).|Lua error in Module:WikidataIB at line 466: attempt to index field 'wikibase' (a nil value).]]. |
This article "Database Deployment Manager" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Database Deployment Manager. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
