dbForge Schema Compare for SQL Server Introductory Tutorial

Learn how to quickly compare database schemas, analyze differences and generate synchronization script.
Learn more: http://www.devart.com/dbforge/sql/schemacompare/

---

Closed Caption:

Welcome to dbForge Schema Compare for SQL
Server Tutorials.
In this tutorial, we will learn how to:
setup comparison process,
analyze and synchronize differences between
databases.
From the Start Page of the application,
you can easily access recently saved
comparison projects
as well as the high-usage tools and Devart
resources.
Let's create a new comparison project.
Run the Schema Comparison wizard.
Let's select Source and Target databases for
comparison.
Alongside a live database, we can compare
various data source types: a database, a
database snapshot,
a native SQL Server database backup,
and a snapshot revision in a version control.
As Source, we select the AdventureWorks2012
database from MSSQLSERVER2012,
as Target, we select the AdventureWorks
database from MSSQLSERVER2014,
To customize comparison process,
let's switch to the Options page.
To quickly find the required option, just enter
few characters of its name in the Find box.
We'd like to compare databases ignoring
extended database properties
and without automatic recomputing of out-of-
date statistics.
You can save all settings as a command line
arguments file and use it for scheduling
comparison and synchronization tasks.
On the Schema Mapping wizard page, you can
customize automatic schema mapping.
For instance, you can compare schemas with
different names or perform the many-to-one
comparison.
On the Table Mapping page, you can see
the result of automatic table mapping.
You can remap tables, columns and keys
manually.
You can also restore default mapping and see
the unmapped objects.
On the Object Filter page, select what types of
objects you want to compare.
Now we can start comparison.
As you see, comparison results are
automatically grouped by Status.
We can re-group them by object type or by
operation performed during synchronization.
You can also exclude any object from
synchronization.
In the bottom of the comparison document, you
can review DDL differences for the selected
compared objects.
Besides, you can preview the synchronization
script for each object.
You can also zoom font size in or out.
So we have analyzed the compared objects.
Now, let's start the synchronization wizard
to customize the synchronization process.
Define how to use the synchronization script:
open, save, or execute. We'd like to
p review the synchronization script.
Move to the Options page to customize the
synchronization options. We don't need to
Backup target database, so we clear the option.
The Dependencies wizard page shows all
objects that should be included into
synchronization to guarantee the correct result.
On the Issues page, you can resolve
issues for synchronization actions.
The Summary page shows synchronization
actions and warnings.
Warnings inform you that you should undertake
some actions to
prevent, for example, data loss or errors during
execution of the synchronization script.
For a quick navigation through the actions that
will be performed during synchronization, use
the Filter box.
Start synchronization.
Here is our synchronization script.
You have been watching dbForge Schema
Compare for SQL Server Tutorial.
Try out dbForge Schema Compare for SQL
Server for free.
The 30-day trial version is available for download
at Devart official web site.
Thank you for watching.