Hello Good day every one!

We have PowerDesigner repository (installed on Oracle). I have extracted and checked-in all my objects by reverse engineering the objects (say V1). Now, I made few changes to the model (say adding couple of columns) and checked-in (say V2).

My question is how to generate the code (only for the changes and not for the entire database). I know how to compare versions and also version vs. workspace and I can see the tool is showing the differences.

However what I need is how to generate code for that.

If you need any specific details I can share. Thank you for your time, Viswa Viswa

asked 29 Feb '12, 15:33

viswapsp's gravatar image

viswapsp
45112
accept rate: 0%

Save the Model V1 as "Archived PDM", then load the model V2, select Database->Modify Database from the menu and fill in the path to the V1 APM. I would always opt to save modifications in an SQL file rather than updating the taget database directly, but that's yoru decision

(01 Mar '12, 08:49) Reimer Pods

Check out the Sybase PowerDesigner Users Group on linkedin. Really nice guy there that can help you out.

(01 Mar '12, 11:32) Thomas Dueme...

First of all thank you for the responses.

Answer from "Reimer Pods", helped me. Thank you very much.

Database -> Apply Model changes to Database a. Choose either 'using an archive model' or 'Using data source' or 'using model from repository'. b. Generation type -> Script generation (I also agree with generating the script and not directly apply them).

"Thomas Duemesnil" -> Thank you for the direction, I have subscribed for that.

permanent link

answered 01 Mar '12, 11:54

viswapsp's gravatar image

viswapsp
45112
accept rate: 0%

It's not powerdesigner forum.

permanent link

answered 01 Mar '12, 02:26

AlexeyK77's gravatar image

AlexeyK77
70761224
accept rate: 8%

You are right. I would love to have one as forum like this for PowerDesigner. Perhaps Sybase is listening ;-).

(01 Mar '12, 11:30) Thomas Dueme...
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×91

question asked: 29 Feb '12, 15:33

question was seen: 6,050 times

last updated: 01 Mar '12, 11:54