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.

Creating a Subscription

1. On the Instances page, click the target instance name to go to the Basic Information page.
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.
   • Select Push subscription for Subscription Type.
   • Select a synchronization schedule for data subscription. You can customize a schedule by day, week, or month.

6. Select a destination database that the publication is to be subscribed, and click OK.
7. View the created subscription.

   To delete the subscription, click Delete.