Toad World® Forums

Changing DB Type


#1

Is it possible to change DB types after creating model? Or more generically, can I support and generate multiple DDLs for different DB types from a single model?

_mike


#2

If you switch db types, be aware that there are default data type mappings from one to the other in TDM. For example a SQL Server Text column might become an Oracle clob. There are some scenarios where going from database a to b to c and then back to a could result in the series of converts not returning to the same starting point. This is more the exception than the rule.

BUT - why have three physical models that are the same and sync them to each other. The logical model is merely in many ways a physical model devoid of a specific database platform. You could (should) use that as the single source and then sync the logical model to each of the physicals. Then you will not possibly get into grey areas …


#3

Hi,

Bert is right. You can use only conversion options in TDM. (File menu | Sync & Convert | Sync & Convert Wizard or Simple Model Conversion).

TDM allows you to set up conversion settings for data types: Settings | Data Type Conversion Settings (Expert mode must be on.)

Flash movies:
http://modeling.inside.quest.com/entry.jspa?externalID=2063&categoryID=158
http://modeling.inside.quest.com/entry.jspa?externalID=3027&categoryID=158
http://modeling.inside.quest.com/entry.jspa?externalID=2064&categoryID=158

Please see the Help file, Index tab and type ‘conversion’. There are many topics with detailed information.

If you have any questions, please write us back .Thanks.

Regards,

Vladka + TDM Team