PowerDesigner + Reverse engineering

Question

I am using PowerDesigner to model my SQL Server database. I used the reverse engineering option in order to import my database. My problem is that the default data in the tables is not imported.

Does anybody know how to import the data in the tables?

What do you mean by "default data"? Reference data? Constrained values? — APC, Dec 29 '10 at 08:57
The problem is that there is no default place to store the default data (as opposed to an OO model, where you could create class instances). Maybe create a vbscript function to reverse the values for a table, using the currently defined columns,and storing the INSERT script in a Text extended attribute on the table. Then a custom Method on the model to call this function for each table with less than xxx rows. — pascal, Jan 24 '11 at 12:51

score 1 · Answer 1 · answered Apr 03 '11 at 17:10

1

for us such problem obtained too problem was the name of the table with special symbol ('), after that table description Powerdesigner imports nothing from the script

answered Apr 03 '11 at 17:10

arunas

11
1

score 0 · Answer 2 · edited Oct 06 '12 at 09:32

0

It's not possible to reverse engineer a data from the database and store them into a PowerDesigner model.
Instead you are able to define a Test Data Profile for each table, column and generate test data (your default data) from PDM to sql-script.

edited Oct 06 '12 at 09:32

S.L. Barth is on codidact.com

8,198
71
51
66

answered Aug 02 '12 at 08:19

Roman

21
4

score 0 · Answer 3 · edited Dec 14 '16 at 11:15

0

It is not posible directly. However what you can do is next:

extract the necessary data in INSERT INTO %TABLE%"(..... format from some other database client
Right click on table, click "properties" click "script" tab and again "end" tab and paste your INSERTs there

edited Dec 14 '16 at 11:15

frhd

9,396
5
24
41

answered Dec 14 '16 at 10:54

kidbabic

109
2
11

score 0 · Accepted Answer · answered Feb 23 '11 at 06:34

0

this cannot be done using power designer.

answered Feb 23 '11 at 06:34

Ghyath Serhal

7,466
6
44
60

PowerDesigner + Reverse engineering

4 Answers4