Skip to main content

AWS DMS (database migration service) - Homogeneous vs. Heterogeneous database migration

If I have an MSSQL server on-premises and I want to migrate that in AWS cloud (as MSSQL server itself), this is called a homogeneous database migration.

If I have an MSSQL server on-premises and I want to transform and migrate that to a PostgreSQL database in AWS cloud, this is called a heterogeneous database migration. In this case the schema of the source and target database would be different (and also the datatypes, DB codes as the DB engines are different). So, you have to use a tool called SCT (schema conversion tool) to convert the source schema to the target schema (and also code transformation). After this, the DMS (database migration service) can be used to migrate the on-promises database into the AWS cloud (to RDS/EC2).

The major advantage of using DMS service is, the source database would be fully operational while migrating the database.

DMS can also move data between SQL, NoSQL and text-based targets.


Comments

Post a Comment

Popular posts from this blog

How to install/upgrade/downgrade kubectl in Linux (Ubuntu)?

To install the latest version: curl -LO "https://dl.k8s.io/release/$(curl -L -s https://dl.k8s.io/release/stable.txt)/bin/linux/amd64/kubectl" curl -LO "https://dl.k8s.io/$(curl -L -s https://dl.k8s.io/release/stable.txt)/bin/linux/amd64/kubectl.sha256" echo "$(<kubectl.sha256) kubectl" | sha256sum --check sudo install -o root -g root -m 0755 kubectl /usr/local/bin/kubectl kubectl version --client kubectl version To install a specific (v1.19.0) version: curl -LO "https://dl.k8s.io/release/v1.19.0/bin/linux/amd64/kubectl" curl -LO "https://dl.k8s.io/v1.19.0/bin/linux/amd64/kubectl.sha256" echo "$(<kubectl.sha256) kubectl" | sha256sum --check sudo install -o root -g root -m 0755 kubectl /usr/local/bin/kubectl kubectl version --client kubectl version This will install kubectl client. Run minikube start to install kubectl server.
Post a Comment
Read more

Application Load Balancer (ALB)

The ALB spans all subnets in a VPC i.e., it is not inside a subnet but VPC. ALB is bound to Target Groups (TGs). TGs are bound to subnets.
Post a Comment
Read more