Compare and synchronize schemas using dbForge Studio for MySQL!
Learn how to compare and sync MySQL database structure using the tool available in the application.
Learn more: http://www.devart.com/dbforge/mysql/studio/database-synchronization.html
Closed Caption:
Welcome to dbForge Studio for MySQL
Tutorials.
In this tutorial we will learn how to:
- find the differences between the database
objects,
- review the schema update script,
- and synchronize changes between two
databases.
Let's perform the New Schema Comparison.
Choose the source and the target connections,
and select the required databases.
Next, you can setup the Comparison Options
and Save your settings to use them as default
ones.
To simplify the command line settings, save the
comparison parameters to an argument file.
Now let's run the schema comparison process.
Here is the Schema Comparison document,
showing the differences between the objects.
The document also allows you to:
- add a filter,
- view the Schema Update Script,
- generate a Comparison Report in HTML or
Excel format,
- change grouping,
- and add a Status Filter.
Now let's run the Synchronization process.
As you can see, all source and target database
objects are identical.
Now let's run the Command Line,
and comapare databases via saving the
arguments file.
Here is our result.
Next, let's compare databases via saving the
comparison document.
Here is our result.
You have been whatching the dbForge Studio
for MySQL Tutorial.
Thank you for your time.
Video Length: 01:53
Uploaded By: Devart
View Count: 1,005