Contents
Can you add a non SQL Server subscription?
If the publication you are subscribing to has SQL Server subscriptions and the publication is not already enabled for non-SQL Server Subscribers, you cannot add a non-SQL Server subscription. The subscription is a push subscription. The Publisher of the selected publication is Microsoft SQL Server 2005 (9.x) or later.
How to create a subscription to a transactional publication?
In the section Create a subscription to the transactional publication, see step 5. The name of the subscriber instance is not displayed, so I click Add Subscriber, and then click Add SQL Server Subscriber from the drop-down list. Then the Connect to Server dialog box appears.
How are pull subscriptions used in SQL Server?
Most often used with snapshot and transactional replication. With a pull subscription, the Subscriber requests changes made at the Publisher. Pull subscriptions allow the user at the Subscriber to determine when the data changes are synchronized. The Distribution Agent or the Merge Agent runs at the Subscriber.
How to become a subscriber in Azure SQL?
For more information, see Transactional replication with Azure SQL Database and Azure SQL Managed Instance. Select the check box in the grid to enable the corresponding SQL Server or non- SQL Server data source as a Subscriber to the publication chosen on the Publication page.
How do I create a push subscription in SQL Server?
To create a push subscription from the Publisher. Connect to the Publisher in Microsoft SQL Server Management Studio, and then expand the server node. Expand the Replication folder, and then expand the Local Publications folder. Right-click the publication for which you want to create one or more subscriptions, and then select New Subscriptions.
How are merge subscribers handled in SQL Server?
For merge subscribers, a replication administrator must manually reconfigure the subscriber, by recreating the subscription. SQL Server replication supports the automatic failover of the publisher and the automatic failover of transactional subscribers.