Primary Keys not created for new tables

lcrawforlcrawfor Posts: 2
edited March 6, 2008 6:12AM in SQL Compare Previous Versions
When I run sqlcompare and generate a sync sript no primary keys are created for my new tables. Consequently, all the foreign key constraints for child tables fail as well.

Any ideas of how I can get it to create the primary keys?



  • Options
    Michelle TMichelle T Posts: 566 Gold 1
    If you have tables with primary keys in the source database, they should be copied to the target database along with the table. Check that you don't have the 'Ignore Indexes' option selected - primary keys are indexes and will be ignored by this option.

    Other than that, I'm not sure what's causing your problems - if you could give me some more details about the tables in question (ideally by sending a snapshot or backup to michelle.taylor@red-gate.com, but I understand not everyone can do this) and about exactly what options you are using in your project I might be able to work out what the problem wasd.
    Software Developer
    Redgate Software
Sign In or Register to comment.