Previous Topic: Changing the Target ServerNext Topic: Select or Change the Target DBMS


Target Servers and the Physical Model

Before you define the physical properties of your DBMS, you must select the target DBMS for the physical schema. Use the Target Server dialog to select the target SQL or desktop DBMS for the physical schema, and to define default settings for generating the schema.

Note: Choose a target DBMS before you work on the schema. If you do, DBMS-specific datatypes and name length warnings are provided by default.

When you need to compare the information stored on the server with the information defined in your local model, and import or export data from one to the other, you must create an active connection to the target database. You can connect to the system catalog in the target database using one of these methods:

See the table in the DBMS Connection Software for a list of client software required to connect to each target DBMS that is supported by this product.

More information:

Connect to the Database

Define the Default Datatype for New Columns

Define the Default Null Option for New Columns

Convert Datatypes When Changing the Target DBMS

Generic Open Database Connectivity (ODBC)