Red Gate forums :: View topic - Missing Primary key
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Missing Primary key

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
nunz112



Joined: 28 Jul 2011
Posts: 3
Location: Wexford PA

PostPosted: Tue Aug 16, 2011 3:35 pm    Post subject: Missing Primary key Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Tue Aug 16, 2011 4:42 pm    Post subject: Reply with quote

Oh, any chance you have a filestream associated with that table? I think we may have an open bug about this already ( SC-5219 ).
Back to top
View user's profile Send private message
nunz112



Joined: 28 Jul 2011
Posts: 3
Location: Wexford PA

PostPosted: Tue Aug 16, 2011 4:45 pm    Post subject: Reply with quote

no filestreams
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Tue Aug 16, 2011 5:55 pm    Post subject: Reply with quote

OK, I've raised a support call about this. We'll probably be asking you for the table scripts, etc.
Back to top
View user's profile Send private message
jgonzalez



Joined: 31 Oct 2011
Posts: 5

PostPosted: Mon Oct 31, 2011 6:08 pm    Post subject: Reply with quote

Did you have ignore indexes checked? Ignoring indexes also ignores the primary key.
Back to top
View user's profile Send private message
nunz112



Joined: 28 Jul 2011
Posts: 3
Location: Wexford PA

PostPosted: Mon Oct 31, 2011 6:19 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jgonzalez



Joined: 31 Oct 2011
Posts: 5

PostPosted: Mon Oct 31, 2011 6:20 pm    Post subject: Reply with quote

Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group