Introduction
In this article, we will see how to create SQL Server in AWS.
- Concept
- Implementation – Creating an MS SQL Server Database in AWS.
- Implementation – Connect the MS SQL Server Database with local MS SQL Server.
Concept - About
- In the Amazon RDS, we have many database templates provided.
- Amazon Relational Database Services (Amazon Service) is a Web service that makes it easier to set up and scale up and operate in the cloud. It provides basically resizable capacity and is very cost effective for your industry -standard relational database and manages common database administration tasks.
- Amazon RDS manages backups, automatic failure detection, software patching, and recovery.
- The best advantage is you have automatic backups performed when you need them. The Amazon RDS restore process works reliably and efficiently.
- You can use multiple database products like MSSQL, MariaDB etc.
- In terms of security, by the help of AWS Identity and Access Management (IAM), you can set who can access your RDS databases.
Implementation – Creating an MS SQL Server Database in Aws
- Sign into Aws Management Console Portal
- Then Drag and Pin the RDS onto the top.
- Double Click on the RDS
- Click on Get Started Now
- Select Engine
- Select Microsoft SQL Server
- Click on the Next Bottom Button.
- Then Specify Db Details like License-model, db engine version, DB instance class, Storage type, Allocated Storage.
- Set the Db Instance identifier, master username, master password, and confirm password.
- Then, configure the advanced settings like Network and Security, VPC, Subnet group, public accessibility, availability zone, monitoring, and maintenance.
- Click on Launch DB instance.
- So if you don’t have VPC and subnet group , you can select – Create new VPC and Create New Subnet Group from the dropdown list
- After that, you will see the window like this.
- Now click on the instance and click your db and see the configuration details below in the screen.
Implementation – Connect the MS SQL Server Database with local MS SQL Server.
- Copy the Endpoint from the portal.
- Open the Sql Server Management Studio and then give the server name as EndPoint, Server Type as Database Engine , username and password which you already setted up while creation of Amazon RDS.
- Click on Connect.
- Then it will successfully connect your database.
- Create table, stored procedure, Run Query Etc.
- This is how you can connect your application with Aws MS SQL Server Database.
Summary
This is how you can use Amazon SQL Database.