Wednesday, March 28, 2012

RMO vs scriptiong on hybrid 2000 2005 replication

I have created the plication and push subscription on SQL 2000 by running sql scripts. I can view it through management console already.

but on SQL 2000 server, i dont' know how to start the snapshot agent and how to synchronize explicitly. In 2005, there is a system sp

sp_startpublication_snapshot @.publication = @.publication

can do the job. can you tell me how to do the same in the sql 2000?

additionally, I tried to use RMO to implement the replication. but it seems some of the classes only support 2005. doesnt' it means RMO can't be used to program on hybrid replication environment?

plz reply. thanks

In SQL 2000, you'll have to query for the snapshot agent job name and call sp_start_job.

To program replication in SQL 2000 you can use activex controls, or you can install SQL 2005 components on the boxes and use RMO, but as you see you'll be limited to classes that support SQL 2000 only.

No comments:

Post a Comment