When you are working with data modeling, you may need to change the target DBMS from one server to another. You can perform most of the conversion automatically when you reverse engineer the database and then change the target DBMS.
When you change the target DBMS, you can convert the datatype assigned to each attribute to the closest datatype available on the new target server. Specific datatype mapping rules are used when converting datatypes.
When you confirm that you want to convert datatypes, you can also convert domain datatypes. If you choose not to convert domain datatypes and you have created domains in the model, the datatype settings for those domains are not updated to reflect the new target DBMS. You must manually update those datatypes so they work correctly with the new target DBMS.
Note: If there is no matching datatype available on your new target DBMS for one or more attributes in the model, you can generate a datatype mapping exception report that lists the unconverted datatypes. Use the report as a checklist when you manually convert the datatypes that could not be converted.
|
Copyright © 2013 CA.
All rights reserved.
|
|