Prev: Merge Repl: Changing Profiles Has No Effect
Next: URGENT -- Disconnecting from Publisher.
From: Manoj Rastogi on 27 Jan 2010 14:44
Hi,
We are using Merge replication between SQL Server 2005 and 2005 Express
edition. Sometimes due to retention period or someother issues we are not
able to sync the data. I am working on utility to do the data upload to
publisher database. So far we are able to create all the required sql
statements including the disabling of identity_range constraints. But it
looks the moment first insert is executed the replication triggers are fired
and they enable the identity_range constraints. Is there any way to tell sql
not to fire the triggers (I tried disabling them but no luck as it gives
error). I am assuming when the merge agent does sync the triggers are not
fired or some how identity_range constraints are ignored. Any help is
appreciated.

Thanks

Manoj
From: Paul Ibison on 28 Jan 2010 11:09
I'd use DataCompare for something like this. The identity columns are marked
as NFR which is how the merge agent does the inserts. In your code you'll
neet to set identity-insert to on - DataCompare should have this option.
HTH,
Paul Ibison
From: Manoj Rastogi on 28 Jan 2010 13:18
Hi Paul.
I have generated all the script which DataCompare will do. The problem is as
there is an identity range constraint it gives an error. I am disabling the
constraint but it looks the insert trigger(created by replication) will
enable it.
I will try using Datacompare and see how it looks.

Thanks
Manoj
"Paul Ibison" wrote:

> I'd use DataCompare for something like this. The identity columns are marked
> as NFR which is how the merge agent does the inserts. In your code you'll
> neet to set identity-insert to on - DataCompare should have this option.
> HTH,
> Paul Ibison
From: Manoj Rastogi on 28 Jan 2010 14:02
Hi Paul,
I even tried Datacompare but the script it created didn't work. I am trying
to keep the identity columns values as in subscriber database.

Thanks

Manoj

"Paul Ibison" wrote:

> I'd use DataCompare for something like this. The identity columns are marked
> as NFR which is how the merge agent does the inserts. In your code you'll
> neet to set identity-insert to on - DataCompare should have this option.
> HTH,
> Paul Ibison
 | 
Pages: 1
Prev: Merge Repl: Changing Profiles Has No Effect
Next: URGENT -- Disconnecting from Publisher.