Versions Compared

Key

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

...

To refine comparisons in the Mapping tab

  • Click the Mapping tab.
  • Select the databases you want to compare; usually they have the same or a similar name.
    Image Modified

    Info

    Use the All and None commands at the bottom of the pane to select all or none of the databases.

  • By default, DB Change Manager does not show the table mappings. To see them, select the Inspect: Checked option on the right side of the Database Mapping pane. The progress bar displays in the lower right corner. The Table Mapping pane shows how and whether the tables map to each other in the two databases.
    Image Added
    The Data Comparison Job editor automatically maps and selects databases and tables between the source and target when it detects correspondences. It indicates when there is no mapping and displays information when it cannot make a match.
    Image Added
  • Select or de-select the check box next to each mapping, as needed. You can adjust incomplete mappings before running the job. Click undefined items in the Target data source column and use the drop down menu to map them.
Info

Click Filter: edit while a pair is selected to use the Columns, Comparison Key, and Filter dialog and further refine the mappings, such as inserting a WHERE clause.

To specify notifiers in the Notification tab

  1. Click the Notification tab.
    Image Added
  2. In the Notification tab, select where DB Change Manager sends notifications when this job is run.

To run the job and see the results

  1. Click the Run Job icon located in the upper-right side of the window.
    Image Added
    The Results tab displays the job progress bar and the results, when available.
  2. Click View in the Results column to view information for an individual pair.
    Image Added
  3. In the Database Results tab, review the detailed results for the tables and rows of the selected databases.


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