This is my first time working with replication and I was wondering if someone could point me in the right direction. I am looking for some sample code or a Web page that describes how to do merge replication using SQL Server Express on the client machines and SQL Server 2005 on the backend. If someone could help, I would appreciate it. Thanks.
If you are familiar with replication on other SKUs (such as standard edition), setting up on Express is not that complicated. You can treat Express just as another SKU, with the following exceptions:
1) Express can only be a subscriber.
2) There is no SQL Server Agent on Express. Thus if you have pull subscription, you can use one of the following ways to initiate synchronization on Express:
a) Using Sync Manager
b) Using ActiveX
c) Calling replmerg.exe (for merge subscription) or distrib.exe (for transactional subscription) with the proper parameters directly.
No comments:
Post a Comment