Database Architect 2.0  

Database structure design tool. When working with Database Architect, software developer defines database tables, fields, references, etc., drawing them directly in the program's window and generates the database directly from the program.Database Architect is a software that defines database tables, fields and references.

Database Architect uses WYSIWYG principles in entity relationship diagram building. For example, if you need to add a new database table to your database, you click the table icon on the program's toolbar, then place it in the model window and define all necessary table properties (table name, fields, indexes) in the table properties dialog.

Database Architect can check your database model to ensure that it doesn't contain errors before generating the database creation SQL script. When checking a model, the program verifies that your database does not contain duplicate table names, tables without fields, references pointing to nowhere and so on.

Database Architect can generate the sql statements that will create your database in the database server and either save it to a disk file or execute it against an ODBC data source, creating tables, indexes and references in the database.

Database Architect stores database format specifications (data types, table/reference/index creation commands, etc) in the external text files, that allows you to not only edit/update format specifications, but even add new database descriptions to the program! When creating a database from the model, the program uses unified ODBC drivers to connect to the database server.

Limitations:

· File|Open option disabled
· Users can load previously saved databases.

What's New in This Release: [ read full changelog ]



· Added: Database migration script generation.

· Added: Windows tab bar.

· Fixed: Minor bugs were fixed