SQL Compare does not synchronize foreign key names

thomaskthomask Posts: 15
edited June 5, 2008 3:55PM in SQL Compare Previous Versions
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

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.