Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
maxLevel2
minLevel2

  • Inspect the Databases
  • Optionally Reconfigure the Data Source Mapping
  • Optionally request email, logs, or system tray notifications (see Setting job notifications)
  • Run the Data Comparison Job
  • Review Comparison Results
  • Optionally generate a job report (see Creating a job report)

...

To reconfigure the automatic mapping process

  1. In the Options tab, select or deselect Mapping Options. The options are also described in Mapping Options.

    Info

    If you change the mapping options in Preferences, they will become the defaults for all new jobs.

  2. In the Mapping tab, click Refresh Databases and Owners to update the automatic comparison.

Set Job Notification Options

When a job completes, DB Change Manager provides various ways of notifying you. See Setting Job Notifications for details.

Run the Data Comparison Job

After you have specified the options and mappings for a data comparison job, you can run it.

To run a job

  1. Click File > Save to save the job before you run it.
  2. In the upper right of the Data Comparison Job editor, click the Run icon.
    Image Added

While the process runs, the Results tab appears and displays the Comparison Summary pane. This information includes:

  • Source and target data source names
  • When the job started
  • Estimated remaining time for the job to run
  • Elapsed time of the job

...

  • Names of objects currently being compared
  • A progress bar showing percentage completion

Review Comparison Results

After a job run completes, the Results tab shows the Comparison Results table.

Image Added

The Comparison Results table lists:

  • The source and target databases
  • Progress status; either Done, Failed, or, if no pairs were specified, Nothing to Compare
  • The Compare Index percentage of matches
  • The Results

...

  • Column View icon links to details about the comparison job

After running a data comparison job, you may decide to synchronize one to the other. For more information, see Synchronizing Data Repositories.


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse