Missing Primary key

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Missing Primary key

Postby nunz112 » Tue Aug 16, 2011 3:35 pm

I made a script today from my dev to prod box and the primary key did not get made on prod which caused the foreign key constraints to fail, any idea why it would have missed it? it was creating the table on prod
nunz112
 
Posts: 3
Joined: Thu Jul 28, 2011 2:25 pm
Location: Wexford PA

Postby Brian Donahue » Tue Aug 16, 2011 4:42 pm

Oh, any chance you have a filestream associated with that table? I think we may have an open bug about this already ( SC-5219 ).
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby nunz112 » Tue Aug 16, 2011 4:45 pm

no filestreams
nunz112
 
Posts: 3
Joined: Thu Jul 28, 2011 2:25 pm
Location: Wexford PA

Postby Brian Donahue » Tue Aug 16, 2011 5:55 pm

OK, I've raised a support call about this. We'll probably be asking you for the table scripts, etc.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby jgonzalez » Mon Oct 31, 2011 6:08 pm

Did you have ignore indexes checked? Ignoring indexes also ignores the primary key.
jgonzalez
 
Posts: 5
Joined: Mon Oct 31, 2011 6:02 pm

Postby nunz112 » Mon Oct 31, 2011 6:19 pm

Yes I did but I would like it to create the primary key even in these instances especially when this is going to be the creation of the table.
nunz112
 
Posts: 3
Joined: Thu Jul 28, 2011 2:25 pm
Location: Wexford PA

Postby jgonzalez » Mon Oct 31, 2011 6:20 pm

Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that.
jgonzalez
 
Posts: 5
Joined: Mon Oct 31, 2011 6:02 pm


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests