DbConstructor 2.0.1.267
DbConstructor 2.0.1.267 | 4,22 MB
Developed by a developer for developers, dbConstructor speeds up and eases the database creation and maintenance process by means of an extremely user friendly interface. Very large databases are handled without affecting performance.
ERD Diagramming
Complete ERD diagram creation.
Change Management (Oracle / SQL Server)
In place upgrade DDL script generation between database versions.
Powerful Domain Data Type Management
Promotes standardized data types and business rules.
Reverse Engineering (Oracle / SQL Server / MySQL and Access)
Import an existing database schema and start using dbConstructor right away.
Compare and synchronize database structures (SQL Server and Oracle)
Can be used to compare two different databases and generate differences reports and upgrade scripts to synchronize both databases.
Automatic Domain Generation
Domains are created automatically when reverse engineering a database (Existing domains are imported directly, otherwise there are multiple options on how domains are created and named).
Powerful Multiple Grid UI
Intuitive and user friendly interface makes it faster and easier for the end user to navigate large databases for a much broader view of the database structure as a whole.
Script Creation and Management (speed / facility / customization)
User configurable multiple platform DDL script creation can be simplified through the use of wizards (IBM DB2 / Interbase / SQL Server / MySQL / Oracle and PostGre).
Version Control
Maintain multiple versions to be able to control and document the full life cycle of a database schema project.
Schema Verification
Checks against multiple database inconsistencies, which in many cases can be corrected by running Schema Fix Up (below).
Schema Fix Up
Inconsistencies can automatically be corrected, ex: missing foreign key constraint indexes can be created by running Fix Up (One of the biggest single causes of deadlocks in Oracle databases). Redundant indexes can also be identified and removed.
Project Synchronization
dbConstructor can generate your development environment class structures and Insert/Update/Delete stored procedures so that any changes in the database structure will always stay in synch with the development team.