Data Type Conversion For a Table

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.

You might follow this procedure if you have copied a small number of tables into the project from elsewhere, but if you have many tables you can also convert all of them at once within their parent package.

If one of the DBMS types is non-standard or otherwise not supported by Enterprise Architect, you should ensure that the mapping of datatypes from one DBMS type to the other has been defined.

How to

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



See also


Double-click on the Table element in a diagram.

The Table Properties dialog displays, with the Database field showing the current DBMS for this table.




To map the datatypes to another DBMS, click on the Database drop-down arrow and select the target DBMS.




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.



Learn more