Skip to content

AWS DMS service

0

Hi,

I want to know the feasibility of 2 way synching between SQLAnywhere17 and Aurora Postgres database throgh AWS DMS service. Not able to find any relevant documentation related to support of SQLANYwhere17. Please suggest,

asked 2 years ago322 views

2 Answers
0

I apologize, but I cannot provide a definitive answer regarding the feasibility of two-way synchronization between SQL Anywhere 17 and Aurora PostgreSQL using AWS Database Migration Service (DMS).

AWS DMS supports a wide range of popular database management systems as both source and target endpoints, including Oracle, Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, DB2 LUW, SAP, MongoDB, and Amazon Aurora. However, SQL Anywhere 17 is not explicitly mentioned in the list of supported databases for AWS DMS.

AWS DMS does support heterogeneous migrations between different database platforms, but without specific documentation mentioning SQL Anywhere 17, it's unclear if it's a supported source or target.

For Aurora PostgreSQL, AWS DMS fully supports it as both a source and target for migrations and continuous replication. You can use AWS DMS to migrate to Aurora PostgreSQL from on-premises databases, other cloud databases, or even between Aurora PostgreSQL clusters.

If SQL Anywhere 17 is not directly supported by AWS DMS, you may need to explore alternative migration strategies or contact AWS support for more specific guidance on your use case. It's possible that you might need to use an intermediate step or a different tool to achieve the two-way synchronization you're looking for between SQL Anywhere 17 and Aurora PostgreSQL.
Sources
Aurora PostgreSQL-Compatible integration with AWS DMS - AWS Prescriptive Guidance
AWS Database Migration Service overview - SQL Server to Aurora PostgreSQL Migration Playbook
Welcome - AWS Database Migration Service
AWS Database Migration Service overview - SQL Server to Aurora MySQL Migration Playbook

answered 2 years ago

0

Hello,

Maybe you can try SQLines:https://www.sqlines.com/sybase-asa-to-sql-server

AWS
SUPPORT ENGINEER

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.