"CreateFromIntersection" - Can't see all tables

[ampo]

Hi.

After getting Source DB tables and Target DB tables, I user CreateFromIntersection to get list of tables from both.

I have a table that 100% exists in both but it isn't in the result list...

Any idea why it isn't there?

Thanks for your help.

[Brian Donahue]

In order for CreateFromIntersection to map tables, the tables must have "matching" primary keys or unique indexes in both databases.

All tables and views should appear in the mappings collection if the names and schemata match up, but they may be ineligible for comparison.

Programatically, you can check the "Status" property on each mapping to see if the data in the mapped table or view will actually be compared. If not, then you can add primary keys or map manually. Please see the following KB for example code.

http://www.red-gate.com/support/Knowledgebase/SQL_Comparison_SDK/SDK7ColumnMapping.pdf
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521