The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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:

×78

question asked: 29 Feb '12, 15:33

question was seen: 2,580 times

last updated: 01 Mar '12, 11:54