SQL Compare does not synchronize foreign key names
thomask
Posts: 15
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
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com