I was presenting at a meetup on Monday showing how to use Visual Studio 2019 to publish web applications to AWS. I got a question during the break that was something like.
So I understand that you can host and elastically scale my ASP.NET application, but what about my SQL database?
The gentleman was under the impression that they only option was to build his own SQL server on top of Elastic Compute Cloud Instances.
This is not the case. We have a service at AWS called Amazon Relational Database Service (RDS) and it allows you to create a database in AWS quickly and easily. It can be used to create a managed Microsoft SQL Server. AWS will take care of the maintenance and patching and you get a database server that you can use in your applications.
It supports all the different types of Microsoft SQL server, (2008 R2, 2012, 2014, 2016, and 2017) including Express, Web, Standard and Enterprise
If you want to see how your database would run in AWS, one of the easiest ways to get started is to take a back up of your existing database and do a restore on to the RDS service. Check the docs for more information:
If you’d like to compare our pricing you can check it out here: https://aws.amazon.com/rds/sqlserver/pricing/