1 Answer
- Newest
- Most votes
- Most comments
0
Almost all the vendors supporting ongoing replication are based on transaction log- a feature that Oracle, SQL Server and MySQL have. This applies to AWS DMS as well as 3rd party tools such as Attunity.
If real time replication is not a requirement then one option is to use a JDBC connector program that can be scheduled to run. The rational of such program is to track changes according to an incremental column in the table- either timestamp or unique sequential value. This is similar to https://redshiftsupport.matillion.com/customer/portal/articles/2955330.
answered 5 years ago
Relevant content
- asked 7 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- Why is no data migrated from my Amazon S3 source endpoint even though my AWS DMS task is successful?AWS OFFICIALUpdated 2 years ago