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 for each Table.

You might use 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 check that the mapping of datatypes from one DBMS type to the other has been defined.

Map the DBMS type of a Table to another DBMS type

Step	Action	See also
1	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.
2	To map the datatypes to another DBMS, click on the 'Database' drop-down arrow and select the target DBMS.
3	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.

Step

Action