Tuesday, February 21, 2012

replication insert from subscriber

:confused:

I want to call a stored procedure to do the insert into my published arcticle/table. Is this possible? I know you can call a stored procedure to insert into the subscriber arctiles.

The problem is the published database has a generated primary key (max +1 )that is calculated via a stored procedure during all inserts. I would bring the stored procedure over to the subscriber but that would not help since the values in the target table will not be 'current' because the subscriber database is only updated nightly.

Thoughts?What replication is it? Snapshot, Trx, Merge? What type? Push, Pull, Push RAA? Be more specific and someone will help.|||I am using merge replication with 'push'|||Manually generated PK based on INT datatype is not a good idea in merge replication scenario. For that you need GUID or a combination of INT and another field that would uniquely distinguish the physical location.|||Hi all!
I have just worked with Replication data, i can replication data between two server in local by program (script, VB) but i can't do that with a server in local and server on internet. Can you send me source (script, VB) do that?. Thanks!

No comments:

Post a Comment