Creating a Subscription

Scenarios

You can add a created publication for your RDS for SQL Server instance to synchronize data from the instance to the subscriber through a distributor.

Constraints

• RDS for SQL Server does not support cross-region publications or subscriptions.
• You can add multiple publications for one instance.
• RDS for SQL Server Web Edition instances cannot be used as distributors or publisher instances, but can be used as subscribers.
• Only one publication can be added to a database.
• The floating IP address and port number of an instance with a publication or subscription created cannot be changed.

Compatibility Between Publishers and Subscribers

Creating a Subscription

1. On the Instances page, click the DB instance name.
2. In the navigation pane, choose Publications & Subscriptions.
3. On the Subscriptions page, click Create Subscription.
4. Click Add Publication.
5. In the displayed dialog box, configure parameters and click OK.
   • Select distributors and publications, and click to synchronize the selected publications to the right box.

     For details about the publisher and subscriber types supported by RDS for SQL Server, see Compatibility Between Publishers and Subscribers.

   • Select Push subscription for Subscription Type.
   • Select a synchronization schedule for data subscription. You can customize a schedule by day, week, or month.
   Figure 1 Adding a publication
   

6. Select a destination database that the publication is to be subscribed, and click OK.
   Figure 2 Selecting a destination database
   

7. View the created subscription.
   Figure 3 Subscription
   
   • To delete the subscription, click Delete.