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.
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?Thanksabdul |
|
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.aspxSQL 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.ThanksRishi Maini |
|
|
abdul
Starting Member
28 Posts |
Posted - 2006-09-15 : 10:58:19
|
Thanks Rishi |
|
|
|
|
|