How To Create SQL Database In AWS

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.