Make tables available to the sources and targets in the EDMM by performing the following task for the source server and target server.
-
Right-click the source server you created, then select Refresh Available Tables in the menu that displays.
The Refresh Available Tables dialog displays. Use the Refresh Available Tables dialog to retrieve information from the server’s system catalog for source and target tables.
-
Enter or select one or all of the following to filter the tables whose information is retrieved to the EDMM cache:
-
Database name
-
Table owner name. See Owner, Database, Creator, Library.
-
Table name (unqualified)
Each name is case-sensitive and may contain special characters (except %,- which are used as wildcards). The exception is MS SQL Server object owner names that have embedded periods (.); these are not supported.
You can select from the drop-down list, enter an exact name, or use wildcards to specify names that include specific characters. You can have alphabetic characters capitalized while or after you enter them by selecting Upper case. You can fill or refresh the drop-down list(s) by clicking the Refresh list button. All text boxes do not appear for each server type.
Note: If you do not enter information in the Refresh Available Tables dialog, but instead just click OK, all tables defined on the server are added to the list of Available Tables. This can take some time to complete. -
-
In Name, enter the unqualified name of your source table. Provide its qualifiers in the fields above Name.
-
Select Retrieve columns and indexes with tables.
This shows you a list of columns and indexes associated with each catalog object retrieved, as shown in the following example.
-
Click OK.
The Connect CDC Director retrieves and caches the table information. When complete, a message about the tables retrieved is displayed.
- Expand the Available Tables branch to view the list of tables available to be sources or targets in your EDMM.
- Repeat these steps for your target server.
-
If required, do the following to create a catalog report in a text window without updating the EDMM:
-
Do one of the following:
-
To create a catalog report for multiple servers, select each of the servers, then go to step c.
-
To create a catalog report for one server, go to step b.
-
-
Right-click a server you want to include in the report.
-
In the menu that displays, select Catalog Synchronization Report and one of the following:
-
-
This Server Only
-
All Selected Servers
The report runs and displays when complete.