Copied tables not matching

Neil_C

Hi!
I'm a relative beginner here so appolgies in advance if this is a stupid question. I'm setting up a Dev and Prod environment for a new schema on a database and am trying to use compare to confirm that the evironments are identical.

I've done this with other schema on the same database with a preexisitng setup of tables in Dev and Prod without a problem, but now I'm running into trouble. The identical setup of tables are showing up as two lists (Only in Dev and Only in Prod). I've tried copying over via export in SQL Server Management Studio and by deploying the tables (without data) in Redgate Compare. The schema have identical names and the tables have identical names but Compare just doesn't seem to want to see them as the same thing. Any tips?

Neil_C

A restart of the computer and a brand new project in Compare and now as if by magic all my tables map perfectly. Quite embarrassing really....  Thanks for your input in trying to solve the problem

BrainDonor

Script the tables out from both sides and check for differences. My guess would be the Primary Key - it won't be present in the table that you created via the export functionality.
Where Compare can't find a common Primary Key, it can't compare, until you manually tell it what to use as a comparison key.

David Atkinson

Might you have accidentally unmapped them? Worth checking this by visiting the Owner Mapping feature.

Neil_C

Thanks for the tip David. I checked the mapping under Owner Mapping and the schema are matched, so it's not that.