How to Compare two Databases for differences using dbForge Schema Compare for MySQL?

In this video, we will show you how MySQL Schema Compare by Devart can help you to quickly and accurately compare and deploy databases whether you're moving object changes from test to production or backwards. It provides possibility to compare objects in MySQL or MariaDB databases and deploy changes to Percona server, Oracle MySQL Cloud, Amazon RDS, Alibaba Cloud or vice versa.

Learn more about dbForge Schema Compare for MySQL:
https://www.devart.com/dbforge/mysql/schemacompare/

Download a 30-day free trial of dbForge Schema Compare and start deploying with zero errors:
https://www.devart.com/dbforge/mysql/schemacompare/download.html

Subscribe to our channel:
https://www.youtube.com/user/DevartSoftware/

#MySQL #SchemaCompare #MySQLTools #dbForge #Devart

00:00 Introduction
00:33 Create a new comparison project
00:40 Select the Source and the Target
01:15 See the comparison result
01:57 Launch the Synchronization wizard
02:21 Set up a synchronization script
02:40 Audit the deployment script
03:06 Apply script against the target database

---

Closed Caption:

The Schema Comparison tool by Devart can help
you to quickly and accurately compare and
deploy databases whether you're moving object
changes from test to production or backwards.
It provides possibility to compare objects
in MySQL or MariaDB databases and deploy changes
to Percona server, Oracle MySQL Cloud, Amazon
RDS, Alibaba Cloud or vise versa.
When you create a new comparison project,
Schema Comparison wizard opens where you can
easily specify the source and target databases
you want to compare.
The tool allows comparing a database project
located in a scripts folder put under a version
control system with a live database.
This is particularly useful when object-level
recovering is required.
Having selected the Source and the Target,
you can either start the comparison instantly
or move to configuring the comparison process.
That can be done on the Options page of the
wizard where you can tune the tool’s
behavior by setting Schema Compare to include
or ignore certain types of changes.
For your convenience, a brief description
is provided for each option.
On the Object Filter page you can exclude
the object types that needn’t to be
compared.
Well then! Time to hit schema comparison!
As you can see the comparison is lightning
fast.
The result of comparison is grouped by type
of difference.
The results pane displays objects that exist
only in the Source, objects that exist only
in the Target as well as objects that exist
in both data sources and are different or
identical.
If you click the object from the Different
group you'll see the sequel script for it
with code differences highlighted. At this
stage you can review of share these differences
with your colleagues before proceeding.
Ok. Now let's select all differences and then
launch the Synchronization wizard to create
the deployment script that will move the changes
you selected from your Source over to your
Target.
On the Output page of the Synchronization
wizard you can choose a deployment method.
You can open or save the deployment script
for further review.
The tool also enables you to run the script
file in MySQL Workbench or using the command
line if you are deploying to multiple targets.
Or you can allow dbForge Schema Compare to
execute the script directly against the target
database.
You can set up a synchronization script options
on the Options page of the wizard.
The Dependencies page displays a list of objects
that haven't been explicitly selected for
synchronization, but these objects are used
by one or more objects that have been included
in the deployment.
On the Additional Scripts page you can augment
the deployment script with your own pre- or
post synchronization scripts.
On the Summary page you can review the warnings
that can affect the deployment and the actions
that will be taken.
Now, let's audit the deployment script.
As you can see, the synchronization script
generated by dbForge Schema Compare is accurate,
concise, and easy to read which is essential
if your coworker will have to review or execute
it.
After you've finished analyzing the script,
you can apply it against the target database.
Well, lastly let's re-compare to make sure
that the synchronization script has been applied
successfully.
Download a 30-day free trial of dbForge Schema
Compare and start deploying with zero errors.