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.
Read and make sure how easy schema comparison and synchronization is with dbForge Schema Compare for MySQL. Click the screenshots for details.
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.
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.
You can customize comparison behavior, e.g., to ignore some objects or properties. Go to the Options wizard page and select the required check boxes.
Tip: Save the comparison settings as a command line arguments file by clicking the link at the top. Later you can use this file for automatic comparison and synchronization through command line.
Tip: To save the current selection of options as your defaults, click the Save As My Defaults button.
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.
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.
Command line interface of dbForge Data Compare for MySQL and Windows Task Scheduler can help you automate routine schema comparison and synchronization tasks. You can create a *.bat file and schedule executing it in Windows Task Scheduler to keep schemas of your databases always in sync.
We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.