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, follow the steps below:
- Double-click on the table element in a diagram to open the table Properties dialog.
- 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.