How to Compare And Synchronize Oracle Table Data with dbForge Data Compare for Oracle

In this video, you will see how Oracle Data Compare tool by Devart can help you to quickly and accurately compare and deploy database contents whether you're moving data from test to production or backward.

The tool provides a full support for Oracle server versions (from 9i to 20c) as well as Oracle on Amazon RDS.

You can share the comparison results with your colleagues and store data comparison differences in Excel, HTML, and CSV file formats.
dbForge Data Compare for Oracle allows you to automate and also schedule synchronization tasks by using the command line interface.

Timestamps:
0:00 Introduction
0:26 Create a new comparison project
0:42 Customize the comparison process at the Options page
0:52 Mapping Page
1:23 The result of comparison
1:53 Launch the Synchronization wizard to create the deployment script
2:17 Audit the deployment script
2:32 Apply the script against the target schema

☑️ For downloading a 30-days free trial of the Oracle Data Compare please visit:
https://www.devart.com/dbforge/oracle/datacompare/download.html

☑️ Try Schema and Data Compare for Oracle in one solution for free here:
https://www.devart.com/dbforge/oracle/compare-bundle/

#Oracle #DataSync #DataCompare #OracleDatabase #dbForge #Devart #OracleTools

---

Closed Caption:

The Data Comparison tool by Devart can help
you to quickly and accurately compare and
deploy database contents whether you're moving
data from test to production or backward.
It provides THE ABILITY to compare data in
Oracle databases and deploy changes to Oracle
server or cloud.
When you create a new comparison project,
Data Comparison wizard opens where you can
easily identify the source and target schemas
you want to compare.
Then you can either start the comparison instantly
or customize the comparison process.
That can be done at the Options page where
you can configure the auto mapping and specify
the comparison behavior.
For your convenience, a brief description
is provided for each option.
At the Mapping Page you can include or exclude
objects from comparison.
Object Mapping dialog window allows you to
map tables and views having different names.
The dbForge tool can also compare the table's
data with the results of a custom query.
To filter rows being compared you can set
a WHERE clause for each table if you wish.
Oook!
Let's hit to compare now!
As you can see the comparison is extremely
fast.
The result of comparison is grouped by type
of difference.
At this tab you can view the data that is
present only in the Source.
There is also a tab displaying the records
that are different, and a tab with the data
that exists only in the Target.
These tabs allow you to spot the new records,
different records, or those that might be
lost in your database.
You can scroll through the differences and
choose which ones you want to synchronize
by selecting the check-boxes in the comparison
result pane.
Now let's launch the Synchronization wizard
to create the deployment script that will
move the changes you selected from your Source
over to your Target.
At the Output page you have three options
depending on the deployment process you'd
like to follow.
You can open the deployment script for the
review or save it to run later.
It's really useful if you want to run the
script against the multiple targets or if
you don't have access to the target environment.
Or perhaps you have an audit process that
requires saving off the scripts.
This is a great way to use the tool as well.
Also you can allow dbForge Data Compare to
execute the script directly against the target
server.
You can set up a synchronization script at
the option page.
At the Summary page you can review the warnings
and the actions that will be taken.
Let's audit the deployment script.
As you can see the synchronization script
generated by dbForge Data Compare is accurate,
concise, and easy to read which is essential
if other colleagues will have to review or
execute it.
After you've finished analyzing the script
you can apply it against the target schema.
By the way, don't forget to backup the target
schema before doing that.
Now, let's re-compare to make sure that the
deployment script has been applied successfully.
Just download a 30-days free trial of the
dbForge Data Compare Oracle and enjoy fast
and easy data deployments with zero errors.