Database Design Studio - Professional (DDS-Pro), includes all of the power packed database modeling features found in Database Design Studio - Lite, (DDS-Lite) plus the full integration of reverse engineering for the most complex relational database.
Using the reverse engineering wizard, you can produce a complete conceptual and logical model of your physical database in mere minutes. The entity relationship diagram and the data structure diagram are fully orthogonal layouts of the relational system requiring no end user editing to understand the database design.
With full support for sub-model layering, DDS-Pro makes the task of complex model management a snap. Isolate the complexity, spread it out over several layers, then understanding the design of the database is a breeze.
This is the ideal tool for the database design professional that is migrating a DBMS, the data center manager who needs to maintain their databases, the web designer that needs to understand the database back-end, the consultant that is doing data migration, and everyone who is responsible for database documentation.
For the professional database designer, there are wizards for creating Transact SQL objects such as triggers and procedures, as well as the Drag-and-Drop View Designer for creating simple, or complex correlated views of database tables.
Apart from creating DDL scripts, DDS-Pro includes the built-in functionality to create your database directly from the conceptual model. Fully integrated DBMS toolsets as well as Active Connection script editors make the updating of databases a breeze.
Rounded off with the integrated Project Manager for file management, Database Design Studio - Professional is the only application needed for managing and organizing the entire database project.