Page History
...
- Click the Discover Data Sources icon at the top of the Data Source Explorer view.
- In the Discover Data Sources wizard, select the locations to search for data sources, and then click Next.
Select the data sources you want to add to the DB Change Manager environment, and then click Finish.
The new data source or sources appear in the Data Source Explorer.Info An alternative to using the Discover Data Sources wizard is to click File > New Data Source and set its connection properties.
- In the Data Source Explorer, right-click on a data source and select Properties to work with connection properties for the datasource.
Creating a data comparison job
...
- Click File > New > Data Comparison Job.
- Use the Select a Project dialog’s Create New button to open a dialog that lets you provide a name and location for a project for this exercise. Select the new project from the Select a Project dialog.
dialog - In the Overview tab, type the name of the job in the Name field.
- Click and drag a data source from Data Source Explorer to the Data Comparison Source box.
By default, all databases in the data source are selected. If you prefer, use the menu to specify a single database. - Click and drag a data source from Data Source Explorer to the Data Comparison Target.
- Click File > Save or type Ctrl+S to save the job.
To customize the job in the Options tab
- Click the Options tab.
- In the Options tab, review the various settings available to you. In particular, select or de- select the check boxes in the Mapping Options section.
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.
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.