Reverse Engineering MySQL Database

You can reverse engineer the existing MySQL database. This means that you can extract the database tables, attributes, relationships, indexes and other object from the database to your diagram.

To reverse engineer MySQL database:

1. Choose File | Reverse Engineer | MySQL database or press Ctrl-R.
2. If the currently opened diagram already contains some objects, a warning dialog will appear. It requests you to create a new diagram to place the reversed objects or use the currently opened diagram.
   Click Yes to create a new diagram, No to use the current diagram. Cancel to cancel reverse engineering.
   Select Do not show this dialog again to prevent the showing of this dialog again.
3. If connection for the current diagram has not established, Database Connection Manager will be shown. Choose profile from the list of available ones or create a new one to connect to the database you want to revere engineer.
4. The MySQL Database Reverse Engineering tool will be shown.
   You can set reverse engineering options in the Option tab.
   
   Reverce Engineer references
   This option enables extracting foreign keys from the database and creating the appropriate references in your diagram.
   
   Automatically build references if none were reversed
   If there are no physical references extracted, it is possible to build them from logical structure of the database.  
   Enabling this feature leads to automatic reconstruction of references. Such reconstruction works by the following scheme: each column of a table is being compared with all primary keys of other tables, and if the column name and data type match one of the primary keys, a reference between the source column and the key column will be created. 
   This option available for modification only if Build references is checked.
   
   Tables in a diagram row
   This option determine how reversed tables will be disposed on the diagram. 
   Reversed tables will be placed on the diagram in rows with equal distance, this option determine how many tables at most will be in one row.
   
5. In the Selection tab of the MySQL Database Reverse Engineering tool you can choose objects you want to reverse engineer.
   
   

   There are several subtabs: Tables, Views and Stores Procedures. Each of which allows you to select appropriate database objects. Check on a checkbox near an object to enable its reverse engineering.
   Pay attention to the Select All and Deselect All button on the tab, they allow you to select/deselect all objects in the list.

6. Click OK to start the database reverse engineering process. The Output -> Reverse docking window will display the state of the process.
7. The reversed database objects will be placed on your diagram.
   

Reverse Engineering and Import: Reverse Engineering and Import Overview | Import from Access Database | Universal Reverse Engineering

©2005 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.