Toad World® Forums

Model Conversion PER -> PER

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

Hi Jay,

  1. In the screenshot find the settings you need.

second half a bit later...

Thanks…

Sorry, I should have found that on my own.

I look forward to you suggestion on the second topic.

Jay

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

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)

Thanks for all your help.

Jay