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

    Amazon

  • Then Drag and Pin the RDS onto the top.

    Amazon

  • Double Click on the RDS

    Amazon
  • Click on Get Started Now
  • Select Engine
  • Select Microsoft SQL Server

    Amazon

  • 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.

    Amazon
  • Then, configure the advanced settings like Network and Security, VPC, Subnet group, public accessibility, availability zone, monitoring, and maintenance.
  • Click on Launch DB instance.

    Amazon

  • 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.

    Amazon

  • 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.

    Amazon

  • 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.

    Amazon

  • 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.