1 Answer
- Newest
- Most votes
- Most comments
0
Hi,
It sounds like you will need to utilize "AfterConnectScript" as mentioned here. [1]
Alternatively, you can use the AfterConnectScript parameter of the --my-sql-settings command to disable foreign key checks and specify the time zone for your database.
I was able to create an endpoint with
"AfterConnectScript": "SET time_zone=+00:00",
and
Initstmt=SET FOREIGN_KEY_CHECKS=0;
References: [1] MySQL Target: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.MySQL.html
Relevant content
- asked 10 months ago
- asked 4 years ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 7 months ago
Thanks. I have to check that solution.