Hi,
How can I activate a replication from my own stored procedure and
synchronize subscribers with my merge publication?
I have created and configured everything and just need to start
synchronization from an stored procedure(on demand) instead of scheduling
the merge agent.
Thanks in advance.
AminAmin,
if you want manual synchronization, then the windows synchronization manger
may be used.
If you want it to be set off programmatically from TSQL, then sp_start_job
can be used with the merge agent's job.
If you want programmatic initialization from a program then the Merge
ActiveX control or SQLDMO can be used.
Regards,
Paul Ibison
Thursday, February 9, 2012
(REPLICATION) - Starting synchronization from stored procedure
Labels:
activate,
created,
database,
merge,
microsoft,
mysql,
oracle,
own,
procedure,
publication,
replication,
server,
sql,
stored,
subscribers,
synchronization,
synchronize
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment