How To Create SQL Database In AWS

In this article, we will see how to create SQL Server 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.