Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 When do I need to run the Replication Distribution Agent Utility?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-04 : 09:13:33
Kevin writes "For a Pull Subscription over the internet, do I need to manually run the Replication Distribution Agent Utility myself on the subscriber? (SQL7 Books Online just describes the parameters for this utility.)

Is it available only through 'distrib' in the command prompt? - that's a lot of text to enter.

Is there a wizard for it? - I don't find one in Enterprise Manager.

Thanks a lot"

Ron Soukup
Starting Member

2 Posts

Posted - 2001-12-04 : 23:58:36
You can have a Pull subscription automatically be entered into the built in 'syncronize' applet of Windows (off the accessories menu) - this is an option when you set up the publication & subscription. Then you just use that applet - not the command line. Its quite straightforward.

You can also easily add a "Replicate Now" button inside your app (if you have one) via the ActiveX controls provided with replication for exactly this purpose. (The syncronize applet fact uses this control.)

If you have an old versions of Windows and don't have the 'syncronize' applet, you can get it by installing the offline addons in the Internet Explorer download/setup. I believe its already there in WinMe, Win2000 and certainly in WinXP.

Go to Top of Page
   

- Advertisement -