question

aurnkumar avatar image
aurnkumar asked

AWS SQL Server Read Replicas - publish from private server

Is conceivable to utilize AWS RDS for SQL Server as the goal/focus for a read imitation? I have a database that keeps running on a private MS SQL example in my server farm and I might want to distribute an arrangement of tables to an AWS SQL Server occurrence so I can utilize that case, and conceivably others, to accelerate read-just questions. I realize that AWS has limitations and I needed to know whether the fundamental foundation exists that would enable me to run a distributer and wholesaler inside my server farm and focus on an AWS SQL Server database?
aws
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
If you mean can an RDS instance be used as a read-only replica as part of an AlwaysOn configuration - then no. > The following Microsoft SQL Server features are not supported on Amazon RDS: > > * Always On (2012 Enterprise Edition) > ... https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.