dbConstructor 2.0.1.277
dbConstructor 2.0.1.277 Ranking & Summary
dbConstructor 2.0.1.277 description
dbConstructor 2.0.1.277 has a high speed and an easy database creation process made possible by its user friendly interface. It avoids following the conventional modal inverted tree user interface that has been implemented in almost all database design software so far.
dbConstructor’s user interface is very well designed to enable even the most novices of computer users to accomplish the complex tasks of database creation and management. It enables a user to navigate large databases in a faster and easier way and provides a broader view of the database as a whole. So now with dbConstructor, managing large databases is no longer a daunting task.
Further, dbConstructor has the ability to switch from Oracle to SQL Server database management and vice versa which makes database upgrades far easier than they ever were. Its compare and synchronize database structures enable the user to compare two different databases (Oracle and SQL Server) and generate a differences report and upgrade scripts to synchronize the two databases.
Moreover, the fact that multiple DDL scripts can be generated from a single database model helps the user get rid of the conversion or creation of multiple physical models for every database platform. Also, dbConstructor lets the end user have the ultimate say when it comes to the final results through its personalized scripting functions.
dbConstructor also checks against possible multiple data inconsistencies, which if found can be corrected by using its Schema Fix Up function. Also, the software helps identify and remove redundant indexes and create the missing indexes for foreign key constraints (One of the biggest single causes of deadlocks in Oracle databases). If you are looking for intelligent database management software that makes both Oracle and SQL Server databases compatible with one another then dbConstructor is the software you should consider.
Major Features:
- 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.
- 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.
Enhancements:
- Added SQL_Variant datatype handling and larger scope of zoom ranges.
Requirements:
- 128 MB RAM
- 10 MB Disk
WareSeeker Editor
dbConstructor 2.0.1.277 Screenshot
dbConstructor 2.0.1.277 Keywords
Bookmark dbConstructor 2.0.1.277
dbConstructor 2.0.1.277 Copyright
Want to place your software product here?
Please contact us for consideration.
Contact WareSeeker.com
