Creating Foreign Key on a Table with missing Column

• 
  Before you synchronized, did you check to see if the foreign key was added as a dependency of one of the new tables? Maybe turning off the 'include dependencies' option, at least temporarily, would cause this action to stop happening.

  Brian Donahue September 13, 2006 11:43

  - 0 +
• 
  I tried turning off the Include Dependencies but it did not help.
  
  The foreign key will be added to existing table once the new column is added. Before that happens I need to create a new table whose primary key is contains the values for the new column on the existing table.
  
  SQL Compare when creating a new table should not generate foreign keys on other tables. Instead these foreign keys should be create when those tables changes are promoted.
  
  I tried promoting one table at a time but SQL Compare did not work.

  dbirdil September 13, 2006 12:14

  - 0 +
• 
  Hello,
  
  Sorry, but I need to ask you for some SQL Compare schema snapshots from your databases. Can you please send them to support@red-gate.com? Also, can I verify you're using v5.2?

  Brian Donahue September 14, 2006 00:38

  - 0 +
• 
  Have you sent the schema snapshots? We got some in our email box that appear to be from you, but you are using a different email address.
  
  Thanks!

  Brian Donahue October 04, 2006 17:19

  - 0 +

Add comment

Please sign in to leave a comment.