Generating Database

You can design entity relationship diagram (ERD) in SDE, and export the design to database for constructing tables. In this chapter, you will see how to generate database as well as to learn some of the configuration settings.

Database configuration

Select the database you use. This affects the use of data type in ERD as well as the target of database generation.

Generating SQL for selected entities

Select some of entities in ERD and check the corresponding create/drop/alter statements.

Generating SQL for project

Produce SQL statements for all the entities created in project.

Generating alter statements

Produce update SQL statements from entities.

Export and import database configuration between projects

Export database configuration settings from one workspace to another.

Entering and generating default data

Provide default data to entities created in project.