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