Powerdesigner converts PDM to MYSQl databases, powerdesignerpdm
Use PowerDesigner to design and build a MySQL database
1. Create a database creation script using PowerDesigner
1. Design CDM (Conceptual Data Model)
2. Select Tools> Generate Physical Data Model, select the corresponding DBMS as MySQL, and Generate PDM
3. Select Database-> Generate Database. In the pop-up Database Generation dialog box, select the script access path and script file name.
4. Click OK to generate the database creation script (*. SQL)
You can run the SQL script in either of the following ways:
Method 1:
In the command line (Database not connected), enter mysql-h localhost-u root-p123456 <F:/mytest/testdb. SQL (note that no quotation marks are required for the path !!) Press enter.
Method 2:
Enter source F:/mytest/testdb. SQL in the command line (the database is connected, and the prompt is mysql>) and press Enter.
How does powerdesigner convert Mysql to SQL server?
Open the pdm file, open a chart, and select change current DBMS from the database menu. The select database window is displayed. Select sqlserver in the new dbms drop-down box. If your PDM file contains stored procedures, you still need to manually rewrite the code.
How to import existing tables in the database to powerDesigner to generate a pdm File
4. then choose your script file; 5. click OK; 6. success. There is also version 1. Open the Powerdesigner tool, create a PDM file, and select the database type "ibm db2 udb 8.x common server" that matches it ". Create method: Right-click WorkSpace ----> new ------> physical data nodel in the left-side pane, select the data type you want from DBMS, and click OK, A new workspace is created. 2. Select Reverse Engineer Database under the Database menu. The Database Reverse Engineering dialog box is displayed. Select Using an ODBC data source and ODBC data source (this data source must be set first, you can choose Control Panel> Administrative Tools> Data Source Creation ). 3. Click "OK" to display all tables, views, and users in the database (select the users of the database ). Select as needed and convert to pdm. Figure 4: Click OK to generate the model.