Model Conversion PER -> PER

Toad Data Modeler
1

Hi,

I’m converting a SQL Server 2008 model to DB2 9.7 and Oracle 11g. I have 2 questions…

  1. Is there a way I can customize how attributes are converted? Example NVarchar in SQL Server converts to Varchar in DB2. I would like it to be Vargraphic.

  2. I have some clustered keys in SQL Server. In DB2 you have to create clustered indexes and then define a key for that index. Is there are way to do that automatically?

Thanks,
Jay

2

Hi Jay,

  1. In the screenshot find the settings you need.

second half a bit later...

Help_DataType_Settings.png
Help_DataType_Settings.png927×459 35.8 KB

3

Thanks…

Sorry, I should have found that on my own.

I look forward to you suggestion on the second topic.

Jay

4

Hi Jay,

we’re still working on the second question and will let you know on Monday. There are still some problems with it.

Regards,
Lukas

5

Hi Jay,

finally, it works! So for the second question you asked, the following should work:

  1. Download the attached package.

  2. Copy the package to your user packages folder in your user installation settings like c:\Documents and Settings\lmacek\My Documents\Toad Data Modeler\Standard Installation\Packages{DCB5CB9B-CF65-4350-86B5-285D246FC5AC}.

  3. Then, after launching TDM and running conversion from SQL Server db to DB2 db model, everything should be processed accordingly!

Enjoy! And let me know, please.
Thanks for your patience.

Regards,
Lukas
UserConvertMSDB.txg (9.55 KB)

6

Thanks for all your help.

Jay