How to skip replication identity constraints in SQL Compare

jagadeeps

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

jagadeeps

current ignore list

Tianjiao_Li

Hi @jagadeeps ,

I'm afraid it's not possible in SQL Compare to skip replication constraint identity. They are part of your schema.