dbConstructor 2.0.1.369

dbConstructor 2.0.1.369 offers you a professional database management system utility for speeding and easing the database schema creation and maintenance process

dbConstructor was developed with the main focus on speeding and easing the database schema creation and maintenance process, while maintaining the complete documentation and change management required in today's fast development environment. Maintaining multiple or even a single database platform project can be a very complex task, that will be greatly simplified by dbConstructors tightly integrated but still friendly user interface.

The DDL scripting engine makes the whole script creation process intuitive and easy to manage. DB schema in place upgrade script generation between database versions (only SQL Server and Oracle for the time being) is one of the many features of dbConstructor that users have come to commend.Multiple database platform DDL scripts are generated from a single "Near Physical" database model, eliminating the need to convert or create multiple physical models for each database platform.

Major Features:

1. Change Management (Oracle / SQL Server): In place upgrade DDL script generation between database versions.
2. Powerful Domain Data Type Management: Promotes standardized data types and business rules.
3. Reverse Engineering (Oracle / SQL Server / MySQL and Access): mImport an existing database schema and start using dbConstructor right away.
4. 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).
5. 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.
6. 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).
7. Version Control: Maintain multiple versions to be able to control and document the full life cycle of a database schema project.
8. Schema Verification: Checks against multiple database inconsistencies, which in many cases can be corrected by running Schema Fix Up (below).
9. 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.
10. 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.

Requirements:

• 128 MB of system RAM
• 10 MB avaliable hard disck space