question

VikasPillai-2509 avatar image
0 Votes"
VikasPillai-2509 asked VikasPillai-2509 answered

Merge Replication Web Synchronization with SQL Express subscriber

our publisher is in SQL Server 2012 enterprise and our subscription machines are running SQL Express 2012. We are trying to setup a sync between a Server X(in a corporate network) and an external machine with SQL Express installed. We are tried merge replication using Web Synchronization option. We configured the IIS and are able to access the URL from the browser of subscriber machine. While creating subscription we noticed that in order to use Web URL we have choose Agent run on the Subscriber. SQL Express does not have an Agent.

Can SQL Express as subscriber use Merge Replication (Web Synchronization option ) ?


sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @VikasPillai-2509, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
DavidBrowne-msft avatar image
0 Votes"
DavidBrowne-msft answered

Without SQL Agent you just need to use a batch script to run the replication agent on the SQL Express computer. Often in this scenario there is a desktop application running on the client that drives the synchronization. If there's not you can use the Windows task scheduler. For the code you can run the replication agents directly, or use RMO: https://docs.microsoft.com/en-us/sql/relational-databases/replication/synchronize-a-pull-subscription?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @VikasPillai-2509,

Welcome to Microsoft Q&A!

SQL Server Express cannot serve as a Publisher or Distributor. However, merge replication allows changes to be replicated in both directions between a Publisher and Subscriber. SQL Server Express does not include SQL Server Agent, which is typically used to run replication agents. If you use a pull subscription (in which agents run at the Subscriber), you must synchronize the subscription using Windows Synchronization Manager or RMO. Please get more information from this link.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VikasPillai-2509 avatar image
0 Votes"
VikasPillai-2509 answered

Thank you for the suggestions.

Our publisher/distributor is in SQL Enterprise(on windows server ), but we are trying to sync data from a subscriber, which is a local machine(SQL Express on windows 10 desktop). because of the nature of connection over VPN, we decided to go with web sync option in replication. since, for web sync option we have to run the agent on subscriber machine(options from replication GUI in SSMS), and SQL express does not have agent, so we had this road block.

I have not yet tried this the options suggested by you guys. I will keep this post open(unless if any issue by anyone) and update my progress in this space.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.