Missing table in "CreateFromIntersection"

ampo

Hello.

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.

Chris Auckland

Thanks for your post.

Does the table have a primary key, unique index or unique constraint?

If it doesn't, then SQL Data Compare cannot automatically map the tables, so you will need to manually choose a comparison key for this table.

I hope this helps.