PowerDesigner Reverse engineering MySQL

Description: Sometimes you need to export the tables in your database to PowerDesigner for easy viewing.

One: Download MySQL ODBC

Two: Configure an ODBC data source

Three: PowerDesigner Connection database

Four: PowerDesigner Export data

1.1 mysql ODBC download to MySQL website http://dev.mysql.com/downloads/connector/odbc/5.1.html

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6B/84/wKioL1UvsMLSbuRBAADt_igFiIg192.jpg "title=" 1.png " Width= "558" height= "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:558px;height:250px; "alt=" Wkiol1uvsmlsburbaadt_igfiig192.jpg "/>

2.1 Open Administrative Tools under control Panel

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6B/89/wKiom1Uvr_ihz9FIAAD3ka1cM5A182.jpg "title=" 2.png " alt= "Wkiom1uvr_ihz9fiaad3ka1cm5a182.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6B/84/wKioL1UvsYbQb60UAAD3ka1cM5A267.jpg "title=" 3.png " alt= "Wkiol1uvsybqb60uaad3ka1cm5a267.jpg"/>

2.2 Configuring an ODBC data source

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6B/89/wKiom1UvsKnQ0YzhAAGtVYegAV0284.jpg "title=" 4.png " alt= "Wkiom1uvsknq0yzhaagtvyegav0284.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6B/84/wKioL1Uvsh_Rn5kKAAErIK897yY023.jpg "title=" 5.png " alt= "Wkiol1uvsh_rn5kkaaerik897yy023.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6B/84/wKioL1Uvsjmgvsv8AAErIK897yY310.jpg "title=" 5.png " alt= "Wkiol1uvsjmgvsv8aaerik897yy310.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6B/89/wKiom1UvsUqS5fAdAAGu8m4Pqh8686.jpg "title=" 6.png " alt= "Wkiom1uvsuqs5fadaagu8m4pqh8686.jpg"/>

3.1PowerDesigner Creating physical Data Model

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6B/89/wKiom1UvsTzjRePFAAHT64AWadY123.jpg "title=" 7.png " alt= "Wkiom1uvstzjrepfaaht64awady123.jpg"/>

3.2 Connecting the database

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6B/84/wKioL1UvsuHhrjEzAAEx9S8FHys040.jpg "style=" float: none; "title=" 8.png "alt=" Wkiol1uvsuhhrjezaaex9s8fhys040.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6B/89/wKiom1UvsYyDZJVdAADhbLk05Jc911.jpg "style=" float: none; "title=" 9.png "alt=" Wkiom1uvsyydzjvdaadhblk05jc911.jpg "/>

Workaround: Install both the 64-bit and ODBC (Win7 64 systems)

4.1 Exporting data tables

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6B/84/wKioL1Uvs62gafbeAAFm_7jvSbY631.jpg "style=" float: none; "title=" 10.png "alt=" Wkiol1uvs62gafbeaafm_7jvsby631.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6B/84/wKioL1Uvs63xHD_OAAF-VIlsB88097.jpg "style=" float: none; "title=" 11.png "alt=" Wkiol1uvs63xhd_oaaf-vilsb88097.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6B/89/wKiom1UvslmwQWc9AABozPfie8g924.jpg "style=" float: none; "title=" 12.png "alt=" Wkiom1uvslmwqwc9aabozpfie8g924.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6B/89/wKiom1Uvs-KxsZaOAAByzxVGVRw688.jpg "title=" 16.jpg "alt=" Wkiom1uvs-kxszaoaabyzxvgvrw688.jpg "/>

This article is from the "Everyman" blog, please make sure to keep this source http://caoyt.blog.51cto.com/9978141/1633637

PowerDesigner Reverse engineering MySQL