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 Documentation site
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: 6369
Location: Red Gate Software
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 ).
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
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: 6369
Location: Red Gate Software
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
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