Reverse database and comparing diagrams with visual diff

Select Tools > Object-Relational Mapping (ORM)> Reverse Database... from the main menu

Click Next in Database to Data Model dialog box

Select a driver in Driver drop-down menu

Enter hostname, database name and root, check InnoDB (with constraint) and click Next

Select two entities from Reversed Entities dialog box, drag them to the diagram and click Close to close the dialog box

Right click on the diagram background and select Rename... from the pop-up menu

Name the diagram as Legacy DB

Select File > Save Project as... from the main menu

Enter the file name and click OK in Save Project dialog box

Select File > New Project from the main menu

Click Create Blank Project button in New Project dialog box

Select Tools > Object-Relational Mapping (ORM) > Reverse Database... from the main menu

Click Next in Database to Data Model dialog box

Enter hostname, database name and root, check InnoDB (with constraint) and click Next

Select three entities from Reversed Entities dialog box, drag them to the diagram and click Close to close the dialog box

Right click on the diagram background and select Rename... from the pop-up menu

Name the diagram as new_db

Select File > Save Project as... from the main menu

Enter the file name and click OK in Save Project dialog box

Select File > Open Project... from the main menu

Select legacy_db.vpp and click Open in Open dialog box

Select Tools > Visual Diff... from the main menu

Uncheck Use Working Project and select a project directory and a diagram in Visual Diff dialog box

Select Name in Strategy drop-down menu

Select Model Element in Compare drop-down menu

Click each model element for viewing the differences

Form entity relationship diagrams from legacy and new databases