Setting Up Schema Comparison

Comparing Two Schemas

  1. Open the New Schema Comparison wizard by doing any of these actions:
    • Click the New Schema Comparison button on the Start page.
    • On the File menu, click New Schema Comparison.
  2. In the Connection fields, type or select the names of MySQL Server(s) connections required for comparison.

    Note

    • If no connections are found, click the New button to create new ones. When the Database Connection Properties dialog box window opens, specify the properties of the server you want to connect to.
    • You can edit the selected source and target connections by clicking the Edit buttons.
    • In the drop-down lists of the Connection fields you can click the Manageā€¦ link to open the Connection Manager dialog box. It will help you to create, edit, and delete database connections.)
  3. In the Database fields, type or select the names of the required databases. Each Database field shows the list of all databases available on the selected MySQL server.
  4. (Optional) If you want to ignore some schema options during comparison, go to the Options wizard page.

  5. Click the Compare button to close the wizard and start the comparison.

Tip:

  • To save your time while selecting Source and Target databases, you can copy the details from one side of the wizard to the other by pressing the Copy buttons: Copy1 - to copy Source database details, Copy2 - to copy Target database details.
  • To swap the Source and Target databases, click the Swap button.
  • To close the wizard and cancel the comparison, click the Cancel button.