DATA Tables missing

• 
  Don't know what changed; I deleted and recreated the primary key on the table I wanted.
  
  Maybe 4 invocations later this table started showing up in my choices to compare again....
  
  ...at least I'm on my way now, but strange.

  yarko July 01, 2005 18:01

  - 0 +
• 
  Hi Yarko
  
  Glad the problem resolved itself for you.
  
  If this happens again please let us know so we can look into it.
  
  Regards
  Dan

  Daniel Handley July 04, 2005 07:20

  - 0 +
• 
  I am also missing at least one table in SQL Data Compare.
  
  here are the specs (as found by SQL Compare)
  
  -- Columns
  CREATE TABLE [dbo].[WhatIf]
  (
  [WhatIfId] [int] NOT NULL IDENTITY(1, 1),
  [ParentReminderTemplateId] [int] NULL,
  [QuestionText] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [TargetReminderTemplateId] [int] NOT NULL
  )
  
  GO
  
  -- Foreign keys
  ALTER TABLE [dbo].[WhatIf] ADD CONSTRAINT [FK_WhatIf_ReminderTemplate] FOREIGN KEY ([ParentReminderTemplateId]) REFERENCES [dbo].[ReminderTemplate] ([ReminderTemplateId])
  GO
  ALTER TABLE [dbo].[WhatIf] ADD CONSTRAINT [FK_WhatIf_ReminderTemplate1] FOREIGN KEY ([TargetReminderTemplateId]) REFERENCES [dbo].[ReminderTemplate] ([ReminderTemplateId])
  GO

  jjmartin1248 August 19, 2005 16:04

  - 0 +
• 
  Hello Jeff,
  
  Thanks for that. I still do not see a primary key/unique index/unique constraint there. Hopefully you haven't set SQL Compare to ignore the primary keys!

  Brian Donahue August 20, 2005 05:57

  - 0 +

Add comment

Please sign in to leave a comment.