SQL Server - Manual Upload of Data from Subscriber to Publisher Database

Asked By Manoj Rastogi

27-Jan-10 02:44 PM

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

28-Jan-10 01:18 PM

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

28-Jan-10 02:02 PM

Hi Paul,
I even tried Datacompare but the script it created did not work. I am trying
to keep the identity columns values as in subscriber database.

Thanks

Manoj