Amazon Database Migration Service vs CData Sync

Amazon Database Migration Service (AWS DMS) is a SaaS service for moving relational databases, data warehouses, NoSQL databases and other data stores to AWS or between cloud and on-premises environments. It handles one-time migrations and continuous replication, with support for both like-for-like and cross-engine moves. AWS says more than 20 databases and data warehouses can serve as source or target endpoints. DMS Schema Conversion assesses schemas and converts many code objects, including views, stored procedures and functions, while identifying work that needs manual conversion. DMS Serverless provisions and scales capacity according to transaction volume, billed hourly. Multi-AZ deployment uses redundant replication instances, and interrupted migrations can resume. API and AWS CLI support automation, while CloudTrail and CloudWatch Logs provide integrations. TLS, VPC deployment, PrivateLink and column masking are available. At least one endpoint must be Amazon RDS or EC2; on-premises-to-on-premises replication is unsupported. The AWS Free Tier offers free with credits.

CData Sync replicates data from databases, SaaS applications and APIs to databases, data lakes and data warehouses. CData says it supports over 250 sources and offers a catalog of cloud and on-premises destinations. Pipelines can use incremental loading and, for supported sources, real-time Change Data Capture. ETL and ELT transformations are available through SQL or dbt Core and Cloud. Users can schedule pipelines and receive email, Slack or Teams notifications when workflows finish or fail. Sync can run on premises, in cloud environments or through CData-hosted Sync Cloud, and is listed for Linux, Windows, web, API and self-hosted use. Its APIs and scripting can manage connections and jobs, inspect status and history, download logs, and run custom behavior around jobs. It can adjust destination schemas when source schemas change; its overview says it does not delete destination columns or reduce their size. CData documents TLS/SSL encryption and encrypted sensitive configuration values and reports third-party SOC 2 Type II and ISO/IEC 27001:2022 audits. A 14-day trial is available; there is no free plan.