Commonly used modeling tools are: PowerDesigner and ERWin, the latter has almost been eliminated, but the former is still active. I believe everyone has encountered that the project team has been in operation for a long time, but there is not even an ER diagram. Today, I will explain the reverse generation of pdm by PowerDesigner connecting mysql. PS: There are various old versions on the Internet, and various texts are wrong. Follow this article and you can get it in 10 minutes. It’s that simple.
Assuming everyone PowerDesigner has been installed, and I use the version number 15.1 to crack the Chinese version.
1. Install mysql-connector-odbc-5.1.5-win32.msi This is the driver must be installed, about 4M, Baidu search can be.
2. Open powerdesigner, file-“reverse engineer–“database model name customization–“
Select dbms as mysql 5.0 – “using a data source select data sourceClick on the red circle in the picture, Click configure,
Click the red circle to add a new data source. , the next step is to select the driver installed in the first step, Next, determine.
, fill in the relevant data, write casually in the upper two lines, and the lower 4 lines are the necessary fields to connect to the database. Click OK and jump to Select the newly configured data source in the drop-down box, and click connect,
, click OK to filter the tables to be exported (
Note: If Pdm needs comment (comment), then mysql must be filled out in advance.