Introduction to the use of PowerDesigner first experience _mssql

PowerDesigner Introduction

Purpose of the tool: here I will only introduce his application in SQL Server database, and I don't understand anything else.

The benefits of the tool: personal understanding, the image of the database design, more intuitive and simple design, more convenient analysis of database logic, and the global control of the database.

Pray: Which shrimp there are powerdesigner better and more complete operation of the article, hope to give me and do not move the goods of the siege teachers to share.

PowerDesigner Download and crack

First, download

1, PowerDesigner 12.5 official Download Address

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

Size MB (132,006,349 bytes)

Second, crack

1, after the installation, modify the installation directory of the Pdflm12.dll file, using the UEDIT32 Binary editor to open this file, find: C4 8B E4 FE FF ff convert this string to C4 90 90 90 90 and save (WI N7 or Vista need to change folder permissions before saving

2, the production of license.lic documents

Copy the following and save 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 File

A, open PD12.5, menu tools-> License Parameters ..., display License Management. Click [Next]

B, show license Load window

C, click [Load], select the License.lic file generated above, then show license Key.

D, click Next to display the Select Language window and select PRC.

F, click [Finish], the system prompts the authorization configuration to update successfully!

PowerDesigner Create a demo of SQL tables

1, I first statement, the next introduction of PowerDesigner = PD

2, create the Test_test database in the SQL database

3, open PD, see the upper right corner file--> point Open, see New--> Point Open

4. Don't forget to make sure.

5,

6, after double click Table_1

7, top equals table built, but no fields, the bottom start to add a field, or the top of the pop-up box

8, the field description is very important, must be marked, then you need to double-click the field column

9. Click Apply, OK, and then this table is created, the following we should put this table, insert you create a good test_test database, click on the PD menu bar, database--->configure connections ...

10, and then determine that the choice should be the penultimate, SQL Server, and then

11,

12, then, the PD menu, the database--->generatedatabase

13, may want to configure the link then always point to confirm, point run, OK.

14, that is to witness the miracle of the moment, open your database, you can see in the PD created the user table ran in!!

End:

Another table can be set up constraints, default values, database table-oriented PowerDesigner, etc., you can also change the style of the table .... Here is a tired statement.