dbForge Schema Compare for MySQL Tour

Read and make sure how easy schema comparison and synchronization is with dbForge Schema Compare for MySQL. Click the screenshots for details.

• 
  Click to enlarge

  1. Opening the schema comparison wizard

  
  

  By default, the schema comparison wizard opens, when you launch Schema Compare.

  Tip: Also you can open the wizard by clicking the New Schema Comparison button on the toolbar.

• 
  Click to enlarge

  2. Creating database connections

  
  

  To create a database connection, click the New button in the wizard. The Database Connection Properties window appears.

  Enter the details for the Host, Port, User, and Password fields. This information is required to connect to MySQL Server. Click OK to finish the creation.

  Come back to the New Schema Comparison wizard and select this connection in the drop-down list of the Connection field.

• 
  Click to enlarge

  3. Selecting databases for comparison

  
  

  In the New Schema Comparison wizard select the databases to compare. They are called Source and Target.

  Source is the database which contents is inserted to Target during synchronization. Target is the database which contents you compare and synchronize with Source.

  Tip: To swap Source and Target, click the swap button. To start the comparison, click Compare.

• 
  Click to enlarge

  4. Analyzing comparison results

  
  

  See the full info about compared objects in the SchemaComparison window. Select required objects to synchronize.

  The grid shows all compared objects automatically grouped by their status (e.g., Only in Source, Only in Target, Different, Equal, etc). Under the grid you can see the structure differences of the selected object.

  Tip: For better understanding, filter the objects in the grid, e.g., to see Only in Source objects. To be convinced you will get the desired synchronization result, preview the synchronization script fragment for each object.

• 
  Click to enlarge

  5. Synchronizing database structures

  
  

  Use the Schema Synchronization Wizard to generate a standards-driven synchronization script and tune the synchronization result based on your needs. Click the Synchronize button to immediately generate the synchronization script.

• 
  Click to enlarge

  6. SQL script management

  
  

  Use SQL editor to view and edit synchronization scripts, create and execute queries against the selected database.

  Tip: To open SQL editor, click the New SQL button on the toolbar.

  Tip: When the query is executed, see the query results in the Data window at the bottom. Find rich data management options in the right-click menu.