Specify your connection information for the source Oracle database and the target Amazon Aurora MySQL database. The following table describes the source settings.
For This Parameter
Do This
In order to disable foreign key checks during the initial data load, you must add the following commands to the target Aurora MySQL DB instance. In the
Advanced
section, shown following, type the following commands for
Extra connection attributes
:
initstmt=SET FOREIGN_KEY_CHECKS=0;autocommit=1
The first command disables foreign key checks during a load, and the second command commits the transactions that DMS executes.
