For a new project we want to test pull replication in mssql to replicate database (transactional replication) to multiple db server. I setup the pull replication by wizard in MSSMS and but the replication stucks on uninitialized subscription in the replication monitor.
Steps I have done:
- Created a publication on publisher by wizard (Local Publications > New Publication…).
- Created a subscription by wizard (Local Subscriptions > New Subscriptions…)
Publisher and distributor are on the same host. Subscriber uses SQLExpress. Authentication is done by sql authentication. SQL user used for authentication is dbo on Distributor DB.
What else is needed to initialize the subscription?
Best Answer
If you want to Pull from a SQL Agent, you'll have to schedule and execute the replication job with a custom program or script. Here's an old sample of doing it in PowerShell: