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 Start page opens, where you can launch Schema Comparison wizard and start your common tasks in one click without searching a required command in the menu.

  Tip: Also you quickly open previous comparison projects.

• 
  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.

  For a direct connection to a MySQL server, enter the details for the Host, Port, User, and Password fields. If you want to connect through SSL or SSH protocols, or using HTTP tunneling, move to the corresponding tab in the window and set connection parameters. Click OK to finish the creation.

  Come back to the schema comparison wizard and select this connection in the drop-down list of the Connection field.

• 
  Click to enlarge

  3. Selecting databases for comparison

  
  

  Select the databases to compare. They are called Source and Target.

  Source is the database which content is inserted to Target during synchronization. Target is the database which content 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: Only in Source, Only in Target, Different, Equal, etc. See the structure differences of the selected object under the grid.

  Tip: For better understanding, filter the objects in the grid, e.g., to see Only in Source objects. To be convinced you get the desired synchronization result, preview the synchronization script fragment for any 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.