Copied tables not matching
Neil_C
Posts: 5 New member
in SQL Compare
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?
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?
Tagged:
Best Answer
-
Neil_C
Posts: 5 New member
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
Answers
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.
Product Manager
Redgate Software