Sunday 21 July 2024

Azure, GCP and AWS Comparison wrt to Cloud Database Migration.

Features AWS (Amazon Web Services) GCP (Google Cloud Platform) Azure Pentaho
Sources Supported Oracle, SQL Server, MySQL, MariaDB, PostgreSQL, MongoDB, and more.
 MySQL, PostgreSQL, SQL Server. SQL Server, MySQL, PostgreSQL, Oracle, MongoDB.
Supports all most  most all Databases 
AWS Database Migration Service  AWS Database Migration Service (DMS):

Targets Supported: Amazon RDS (all engines), Aurora, Redshift, DynamoDB, S3.
Features: Continuous data replication, minimal downtime, schema conversion, data validation.
Database Migration Service (DMS):


Targets Supported: Cloud SQL (MySQL, PostgreSQL, SQL Server).
Features: Minimal downtime, automated provisioning of Cloud SQL instances, schema and data migration.
Azure Database Migration Service (DMS):

Targets Supported: Azure SQL Database, Azure SQL Managed Instance, Azure Database for MySQL, Azure Database for PostgreSQL, Cosmos DB.
Features: Automated assessment, continuous replication, downtime minimization.
Pentaho PDI Can be custamized 
 AWS Schema Conversion Tool   AWS Schema Conversion Tool (SCT)
Purpose: Converts database schema from one database engine to another.
Database Migration Workbench (Beta):

A graphical user interface (GUI) tool that helps in assessing, planning, and executing database migrations.
Provides schema assessment and conversion functionalities.
Azure Migrate:

Purpose: Central hub for tracking, assessing, and migrating on-premises databases, VMs, and applications to Azure.
NA
Pentaho PDI Can be custamized  for spacific source and target database engine
 Physical data transport solution AWS Snowball:

Purpose: Physical data transport solution for transferring large amounts of data.
Usage: Useful for petabyte-scale data migrations where network transfer is impractical
Transfer Appliance:

Purpose: Physical data transfer solution.
Usage: For large-scale data transfers where network-based transfer is not feasible.

Azure Data Box:

Purpose: Physical data transfer solution.
Usage: For transferring large amounts of data to Azure where network transfer is impractical.
Pentaho PDI Can be custamized , for bulkload 
Moving large amounts  AWS DataSync:

Purpose: Automates moving large amounts of data between on-premises storage and AWS.
Usage: For continuous or one-time data migrations, including file transfers.
BigQuery Data Transfer Service:

Purpose: Moves data into BigQuery.
Usage: Supports data transfer from SaaS applications, Google services, and other sources into BigQuery.

Cloud Data Transfer Service:

Purpose: Transfers data to Google Cloud Storage.
Usage: Includes online transfer, transfer appliance, and storage transfer service for large datasets.
Azure Storage Migration Service:

Purpose: Transfers data to Azure Storage.
Usage: Supports moving data from on-premises storage systems to Azure Blob Storage, File Storage, and more.
Pentaho PDI Can be custamized for Bkp and restore with any ftp client