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 2005 Forums
 Express Edition and Compact Edition (2005)
 Pull Subscription

Author  Topic 

abdul
Starting Member

28 Posts

Posted - 2006-09-14 : 06:15:33
Are there any procedural differences between Express and MSDE considering pull subscription?

Thanks

abdul

Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-09-14 : 10:47:51
Yaa in Express Edition you can create Pull Subscription despite of the fact that Express does not have SQL Agent, Use Windows Sync to achive the same:-

Again Refer the same link that I mentioned Earlier:-

http://msdn2.microsoft.com/en-us/library/ms165700.aspx

SQL Server Express does not include the SQL Server Agent, which is typically used to run replication agents. If you use push subscription, replication agents run at the Distributor, which will be an instance of SQL Server 2005, so there are options for synchronizing. But if you use a pull subscription, in which agents run at the Subscriber, you must synchronize the subscription by using Windows Synchronization Manager or RMO.

Thanks
Rishi Maini
Go to Top of Page

abdul
Starting Member

28 Posts

Posted - 2006-09-15 : 10:58:19
Thanks Rishi
Go to Top of Page
   

- Advertisement -