Data Type Conversion Procedure

Once a database schema has been set up on an Enterprise Architect diagram (either by importing through ODBC or manually setting up the tables), the DBMS can be changed to another type and the column datatypes are mapped accordingly.

To map the DBMS type of a table to another DBMS type

How To:



See Also


Double-click on the Table element in a diagram

The Table Properties dialog displays



The Database field shows the current DBMS for this table.



To map the column datatypes to another DBMS, select the target from the Database drop-down and click on the Apply button.



The datatypes are converted to match those of the new DBMS, and these are reflected in any DDL generated from this table.