Posts

Showing posts from February, 2020

Short Note on AWS Networking VPC, SUBNET, NACL, SECURITY GROUPS, VPC PEERING, SITE TO SITE VPN, DIRECT CONNECT

Image
Welcome!! In this article, we shall learn about AWS VPC (Virtual Network), Subnet, VPC Peering, NACL, Security Groups, Site to site VPN, and Direct Connect. VPC:-VPC is nothing but, like On-premises network environment, where we use switches and routers to communicate with servers and clients, same as AWS Virtual Private Cloud. It is also used for communicating with AWS resources such as EC2, RDS, etc.
·Per Region, it is limited to a 100 VPCs.  ·VPC is isolated, based on the configuration in Network Access Control List and Security Groups, all resources within VPC can communicate with each other. Subnet:-
Under the VPC, we must understand the Subnet and how it works.
Subnetting is the process of dividing a network into small networks
We can divide the VPC IP range into multiple parts of unique subnet IP ranges.
By default the resources within the subnet will communicate with each other and also communicate across the subnets in the same VPC. We can restrict the communication across the subnet…

Intro to GCP SQL Database server and how to create PostgreSQL Server

Image
In this article, I walkthrough you how to create a Postgres SQLserver in GCP SQL Introduction: -

All you know about that leading public cloud providers are Azure and AWS, both are providing Database as a Service, like that GCP also offering Database as a Service inboth SQL and No-SQL Database servers for customers and users.

How to create PostgreSQL in GCP SQL

Let’s start how to create a Postgres SQL Server in GCP SQL

Before going to start log into GCP Account 
To Create a Postgresql Databases Server→ Click SQL in Google services Pane

To Create a SQL Instance → Click CREATE INSTANCE

Choose which database you want → Click PostgreSQL



Fill the Configuration Details

Instance ID

Oracle to MS SQL Migration

Image
Introduction Welcome! In this article, we are going to learn how to migrate Oracle Database to Microsoft SQL Database. Let’s go through this from scratch. Pre-requisites Download SSMA for Oracle Setup .exeDownload Oracle extension for SSMAMicrosoft SQL ServerOracle Database Let start the installation of SSMA and Oracle Extension, Step 1 - Installation of SSMA Run the downloaded exe file - Click Next Read and accept the license agreement and click Next Click Complete. Click Install to start Installation. You can see the status of the installation. After installation is complete click Finish to exit the setup