1 Answer
0
Accepted Answer
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 4 years ago
Relevant content
- Accepted Answerasked 3 years ago
- asked 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 6 months ago