What are the challenges you face when working across database platforms? Take the survey
Options

How to skip replication identity constraints in SQL Compare

Hi All,

I am running a SQL compare on a database participating in Merge replication, i got output with many tables showing differences between replication constraint identity range difference.

eg:

Server 1:
ALTER TABLE [dbo].[Application] ADD CHECK (([ApplicationId]>(9) AND [ApplicationId]<=(1009) OR [ApplicationId]>(1009) AND [ApplicationId]<=(2009)))
GO
Server 2:
ALTER TABLE [dbo].[Application] ADD CHECK (([ApplicationId]>(1234009) AND [ApplicationId]<=(1235009) OR [ApplicationId]>(1235009) AND [ApplicationId]<=(1236009)))
GO

i was wondering if there is an option to ignore this constraint in the SQL compare.


thanks
jagadeep
Tagged:

Answers

Sign In or Register to comment.