Introduction to the use of PowerDesigner

Introduction to PowerDesigner

Purpose of the tool: Here I will only introduce his application in the SqlServer database, and I do not understand other applications.

Benefits of the tool:My personal understanding, graphic-based database design, more intuitive and simple design, easier to analyze the logical relationship between the database and global control of the database.

Pray: Which of the following is a better and more comprehensive operation article about PowerDesigner stored in the prawns? I hope I can share a message with the target attacker.

Download and crack PowerDesigner

1. Download

1. PowerDesigner 12.5 official

Http://download.sybase.com/eval/PowerDesigner/powerdesigner125_eval.exe (copy to browser or thunder download)

Size: 125 MB (132,006,349 bytes)

Ii. Cracking

1. After the installation is complete, modify the pdflm12.dll file in the installation directory and use the UEDIT32 binary editor to open the file: 83 C4 14 8B 85 E4 fe ff change this string to 83 C4 14 33 C0 90 90 90 90 and save it (win7 or vista needs to change the folder permission to save)

2. Create a license. lic file.

Copy the following content and save it as a license. lic file (note that the extension is lic)

FEATURE PD_SHELL SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 1

FEATURE PD_DEV SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 2

FEATURE PD_DA SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 3

FEATURE PD_STU SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 4

FEATURE PD_DEVE SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 5

FEATURE PD_DAE SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 6

FEATURE PD_STUE SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 7

FEATURE PD_VW SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 8

FEATURE PD_CDM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 9

FEATURE PD_XSM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 0

FEATURE PD_ILM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 1

FEATURE PD_RQM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 2

FEATURE PD_PDM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 3

FEATURE PD_OOM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 4

FEATURE PD_BPM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 5

FEATURE PD_RMG SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 6

FEATURE PD_FRM SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 7

FEATURE PD_RTP SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 8

FEATURE PD_MMR SYBASE 12.50 permanent uncounted 1 TS_ OK HOSTID = ANY SIGN2 = 9

3. import authorization files

A. Open PD12.5 and choose Tools> License Parameters .. to display the License Management Wizard. Click [next]

B. display the License Load window

C. Click [Load] and select the license. lic file generated above. The License Key is displayed.

D. Click [next] to display the selection language window and select PRC.

F. Click [finish]. The system prompts that the authorization configuration is successfully updated!

How to create an SQL table using PowerDesigner

1. I declare it first. In the following introduction, PowerDesigner = pd

2. Create the Test_Test database in the SQL database

3. Open pd and click file in the upper-right corner to open new.

4. Don't forget to confirm.

5,

6. Double-click Table_1 and

7. If the above table is created but no field exists, add the field below, or the above pop-up box

8. Field description is very important and must be specified. You must double-click the field column.

9. click "application", click "OK", and the table is created. Next we should insert the table into the Test_Test database you have created, and click "database ---> configure connections" in the pd menu bar...

10. Then confirm that the selection should be the second to the last, SQL Server, and then

11,

12. Then, the Database ---> GenerateDatabase In the pd menu

13. You may need to configure the link and click "OK" until you click "run.

14. When you open your database, you can see that the user table you created in pd has been running in !!

End:

In addition, you can create constraints for tables, default values, database tables are directed to PowerDesigner, etc. You can also change the style of the tables.