How can we help you today? How can we help you today?

SQL Compare does not synchronize foreign key names

Hi - I am using SQL Compare Pro 6.2.0.271 to compare a SQL Server 2005 database against a script folder.

The structure is identical with the exception of five tables for whom the the foreign key constrainst have different names.

For instance:
ALTER TABLE [dbo].[tb1] ADD CONSTRAINT [FK__tb2__4AF2BAD7] FOREIGN KEY ([tb3]) REFERENCES [dbo].[tb3] ([ID])
GO

ALTER TABLE [dbo].[tb1] ADD CONSTRAINT [FK__tb2__11D9290] FOREIGN KEY ([tb3]) REFERENCES [dbo].[tb3] ([ID])
GO

However, after I run the synchronize function, the difference remains. Does SQL Compare have a problem synchronizing foreign key names?

Cheers,
Thomas
thomask
0

Comments

1 comment

Sort by
  • Eddie D
    Thank you for your post into the forum and sorry for the delay in replying to you.

    Can you please confirm that you do not have the 'Ignore Foreign Keys' option enabled:
    Edit Project ->Options Tab ->Ignore Section ->Foreign Keys

    If the check box is checked, please remove the 'tick' and then repeat your comparison.

    Many Thanks
    Eddie

    Eddie Davis
    Product Support Engineer
    Red Gate Software Ltd
    e-mail: support@red-gate.com
    Eddie D
    0

Add comment

Please sign in to leave a comment.