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

Popular posts from this blog

GoLang - How to check if key exists in map?

package main import "fmt" var m map[string]string func main() { m = make(map[string]string) m["foo"] = "abc" if val, ok := m["foo"]; ok { fmt.Println("foo found -", val) } else { fmt.Println("foo not found") } if val, ok := m["bar"]; ok { fmt.Println("bar found -", val) } else { fmt.Println("bar not found") } } Output: foo found - abc bar not found

How to delete commits in Git?

Suppose you have 3 commits with SHAs as follows: HEAD~0 --> Commit 3 ccccccc HEAD~1 --> Commit 2 bbbbbbb HEAD~2 --> Commit 1 aaaaaaa If you want to remove the last two commits (i.e., commits 2 and 3) and make Commit 1 as the latest commit, run the following commands: git reset --hard aaaaaaa git push origin HEAD --force Now, the commit history would be as follows: HEAD~0 --> Commit 1 aaaaaaa

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

To install the latest version: wget https://storage.googleapis.com/minikube/releases/latest/minikube-linux-amd64 sudo cp minikube-linux-amd64 /usr/local/bin/minikube sudo chmod 755 /usr/local/bin/minikube minikube version To install a specific (v1.11.0) version: wget https://storage.googleapis.com/minikube/releases/v1.11.0/minikube-linux-amd64 sudo cp minikube-linux-amd64 /usr/local/bin/minikube sudo chmod 755 /usr/local/bin/minikube minikube version