Creating database models

Data models in DatAdmin look like normal database. You can use the same tools to define data models as when working with real databases. Browsing database tree, defining tables, even defining static data in data models, all these jobs are performed in the some way. Also you are able to compare and synchronize data model with a real database. Although Integrated Data Modeler omits some advanced features implemented by specialized data modelling tools, it is very good tool to define middle sized models. Thanks to it’s simplicity and drag & drop support it is very easy to learn and use.

Database model in DatAdmin is structure of database stored in local XML file. As usual, you can access DB models in connection tree. For using DB models, you need Professional edition.

Creating empty database model

Select "New" on context menu of folder (e.g. root folder)

In Create dialog, select "Database definition".

You will be asked for database model properties:

• Dialect - SQL dialect used for model. Dialect determines, which objects are available (not all engines supports stored procedures), defines data types and is used for syntax highlighting
• Force single schema - if true, schema names are ignored even on database engines supporting more dialects

Creating database model from existing database

There are several ways, how to do this, one is export database as "Database structure".
Other way is copy database to clipboard

and paste it to root folder using operation "Save structure"

Working with database model

Work with database model is exactly the same as work with database (only you cannot run SQL queries on database model). You can use "Generate SQL" tool to generate script creating a database. Also you can compare and synchronize model with real database.