Using PowerDesigner to convert the table structure in Oracle to a physical data model

Recently, because of the need for work, understand the subtle relationship between PowerDesigner and Oracle, special to share their own summary of the small partners.

First, export the physical data model in Oracle

1, the process of export, is to do a reverse engineering process, you can also use their familiar database modeling tools, the following will focus on the use of PowerDesigner export method.

Preparatory work:

A, install good powerdesigner, this article uses is 12.5 version of.

b, install the Oracle client (32-bit, 64-bit client does not seem to support)

C, if you do not have an Oracle client installed, ignore step B, but if you want to continue down, then you have to have a table script. (ps:sql file yo)

D, my English is not good, so the Chinese have a bit, English good small partner can control on the OK.

OK, text and graphics go up.

2, open PowerDesigner, follow the operation.

Then, choose the database type, here to select Oracle, other types of databases should be the same, please do your own research.

3. Next, we will see two options. One is modeling using database scripting, and one is connecting to database modeling. Below first

Next, use database scripting to model the operation. OK, select Script to go up.

This is the end of the situation, and the rest of the process will be done automatically by PowerDesigner.

4, another situation, perhaps the most common to the situation, the need to connect to remote database modeling. OK, let's use the operation to explain it.

First, choose to use the database, such as operations.

Here to break down the Configure .... Detailed action:

When you select "Configure ..." in the previous step. "After that will go to the following page, the remaining three steps to follow the operation of the next step down is OK."

Step One:

Step Two

Step Three

At this point, our data source has been configured. If you have already configured the data source information in the past, you can go directly to the last step, and choose a table to model.

5. When we connect to the database, click OK on the Select Modeling Data Source window directly to see the following page.

At this point we get the physical data model through reverse engineering, but how does the logical data model get it?

Second, through the physical data model to get the logical data Model template

1. Select the physical data model that you want to convert, and then perform the actions

2, in the Pop-up dialog box, enter the information you want to fill in, click Save.

3, notice that no, purple that =, with it, whenever you modify the name, code will automatically change to the value of name, this is of course we

Reverse engineering don't want to see. Once saved, the value of code will not change with the name value as long as the following settings are set.

Reprint please indicate the original address of the article, enjoy the author's labor results.

Original address of the article: http://blog.csdn.net/zgs_shmily/article/details/46493419

Using PowerDesigner to convert the table structure in Oracle to a physical data model