Toad World® Forums

How To Import a Power Designer model into Toad Modeler

Does anyone know how to import a Power Designer model into Toad Modeler?

We tried several modelers and the company settled on Toad. However our most current work is in a Power Designer model. We would like to keep all the names and codes.

Hello,

Import from PowerDesigner is not supported in TDM3. However, there is a workaround – via TDM2:

  1. Open TDM2.
  2. Select File | Import.
  3. From the Script Selection… box, select Qdesigner/Power Designer models.
  4. In the Import from file box, select the file you want to import.
  5. Press Run.
  6. Main model will be imported.
  7. Feel free to save the model as TDM2 file with extension .DM2.
  8. Open the .DM2 file in Toad Data Modeler 3 (TDM3).

Notes:

  • To ask for license of TDM2, please contact the Quest support team: support@quest.com.
  • If you want to import the model including submodels, please write us to: modeling@quest.com. We will send you appropriate add-in.
  • The import to TDM2 has been designed for Power Designer/QDesigner 10 and 12.0. If you use Power Designer 12.5, please write us too. We will send you appropriate add-in.
  • Import from Power Designer to TDM3 is planned.

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

Regards,

Vladka

Does somebody knows if the import from Q-Designer to TDM3 is still planned or still TDM2 is needed?

Thanks in advance!

Sergio.

Hi,

TDM 2 is still needed - and we currently do not plan to add import from QDesigner to TDM version 3.

Regards,

Vaclav

Hi folks,

I have aproblem importing a power designer model to TDM2. After importing the pdm file all tables are displayed in TDM, but I cannot find my diagrams…

What am I doing wrong?

yours,
Stefan.

Hi,

please make sure you try to import supported database platform. Information about import can be found in Help file (click Help | Index or locate BIN folder in and open ToadDataModeler.chm file) and see topic Features | Import.

Note: only Power Designer 10 and 12 models in XML format can be imported. Newer versions are not supported.

In case you don’t find a solution in Help file, send us model to modeling@quest.com and I will try to import it.

Regards,

Vaclav

Hi Vaclav,

thanks for your fast answer. I am using Sybase Power Designer 9.5.1. Database platform within the Power Designer Model is Oracle 9i. Dataformat is XML.

The importing with TDM2 works fine, but my physical diagrams are not imported. No errors are displayed during importing.

Without the physical diagrams the import is useless for me, because all I get is a bunch of all existing tables in the database and their relationships. I would get the same result if I simply reengineer the database.

The help file is not really helpful, there is nothing written about the physical diagrams.

regards,
Stefan.

Message was edited by: stefan_xavo

Hi,

I think the import doesn’t work fine, unfortunately. Diagram is missing and the problem might be in different structure of XML files. Version 9.5 is not supported. Only version 10 and 12, sorry.

Regards,

Vaclav

Hello,

very good news :frowning:

So I bought TDM4, because Quest Support said “your Power Designer Model can be imported with TDM2, but we cannot give TDM2 until you buy TDM4”.

And now Quest says: sorry, we cannot migrate your data.

What should I do now? Create all diagrams from scratch…??

regards,
Stefan.

Hi Stefan,

let’s see if there is some workaround that might be useful. As I wrote you, only Power Designer v.10 and v.12 models can be imported, but that’s not the only way how to import metadata to TDM. (BTW: The same information was published in this thread almost three years ago - see Vladka’s reply to the original post.)

Please read the following article: it shows a possibility how to get logical information out of XML files.
http://blogs.inside.quest.com/modeling/2010/09/22/how-to-load-logical-information-from-external-sources/

I would like to help you more, unfortunately we do not have access to that old version of Power Designer and all our developers work on items with higher priority. Thank you for understanding it.

If you want, you can send us your models (if you don’t have thousands of them) and we can try to look at possibilities. Please add models to zip archive and send them to modeling@quest.com

Of course, another alternative is to find someone who has a newer version of PowerDesigner and export your models to XML from PD v. 10 or 12.

Finally let me write you that I regret you were not able to test the import before you purchased TDM4, but I hope, as a member of dev team, that you will be satisfied with the product.

Regards,

Vaclav

Hi Vaclav,

thanks for your support! I have send you two of our models. I hope you can migrate them to TDM…

regards,
Stefan.

Hi Stefan,

please check your email. I think we found some solution :wink:

Regards,

Vaclav

Hi Vaclav,

thank you for your fast support. Great work!

yours,
Stefan

Hi Vaclav,

it's me again. After modifing some tables and trying to create an alter script via comparing the new model with the old one I get a reproduceable application exception of TOAD.

What should I do? Is there someting wrong in the model? Was there an issue when migrating the model?

Second poiint is the comparison takes very long. Power Designer made the same job in seconds, TDM takes 2 minutes...

regards,
Stefan.

Message was edited by: stefan_xavo

Hi Stefan,

Vaclav is out of office at the moment, but we will try to help you for him.

You can start with Test Model and check messages for errors. You have to have Epert Mode activated/checked in Settimgs | Options | General.
Right-click the model name in the Model Explorer and select Test Model.
If any errors occur in the Message Explorer, try to repair them.

If the model test runs errorless, I will need the altered model sent to check it and reproduce the error. Please, send it to modeling@quest.com.

Regards,
Lukas

Hi Lukas,

thanks for the quick answer. I sent the models to you…

regards,
Stefan

Hi again,

what’s your PC configuration (both HW and OS)?

Thanks,
Lukas

Hi Lukas,

OS: Win7 SP 1
Hardware: Lenovo Thinkpad T410 (Intel Core i7 620M, 3,2 GHz, 8 GB RAM)

regards,
Stefan.

Thank you. I will update you tomorrow. The same for the case you raised through Support.

Regards,
Lukas

Anyway, when we try generating AlterScript the way you do it, we don’t get the AV… Will investigate further.

Lukas