ApexSQL Diff

Intro to ApexSQL Diff

---

Closed Caption:

welcome to this introduction have a pic
sickle def a pic sickle def compares and
synchronizes data bases
database backups script files including
source control files
and database snapshots so what can you
use it for
let's say you have a database
development and you had a column to
table a
to deploy the changes into production he
simply look at the two versions
find the difference and apply the change
manually a few lines a script later
and you're done well if you add a new
argument procedure be
create forty functions update the bodies
are procedures BC in D
change the primary key table be removed
for counsel table X
and renamed you can see Table de the
playing with this many changes no longer
easy
this is where a pic single death comes
in a pixie kal def does all the work for
you
quickly easily and accurately first
you choose the data sources that you
want to compare data sources can be
database backups
live databases script files including
source control files
or database snapshots once you've
selected as sources
a pic sickle definitely analyze each
data source and display the differences
between the two data sources on the main
screen
select objects for synchronization by
clicking the checkbox
next to the desired object or click here
to select all logic synchronization once
you select your objects
click synchronized to open the second
session was it in synchronization with
you
you can view and choose which
dependencies to include as well as you
the impact to the changes that are about
to be made
we complete the wizard a pic sickle dip
automatically creates an error-free
synchronization script for the two data
sources
now when you compare them again the two
data sources are identical
this is what a pic sickle def does for
you