Ignore NOT FOR REPLICATION

spivey24

We just added replication to our dev environment then took it off, but SQL left NOT FOR REPLICATION settings on all of the identity columns. Now every other table is failing comparison. Is there a way to ignore this column attribute? Setting it to ignore replication triggers and identity properties didn't work.

Thanks.

spivey24

Removed

icewharf

spivey24, did you solve this or find some work-around?

spivey24

No, I never found a solution. We ended up taking off replication on the databases we compare and rolling back all of the "not for replication" changes it made, so it became a non-issue.