AWS DMS – Target TableName Differs

Posted Leave a commentPosted in AWS, DMS

AWS DMS is a tool that supports both homogenous and heterogeneous migration, helping to migrate to aws cloud. During most of the migrations, the source and target table names remain the same, in which case the Mappings.json file is pretty simple. As an example (Oracle to PostgreSQL)  { “rules”: [ { “rule-type”: “selection”, “rule-id”: “1”, […]

S3 Bucket – IllegalLocationConstraintException

Posted Leave a commentPosted in AWS, S3

A quick one !! Creating bucket failed with “IllegalLocationConstraintException” — [[email protected] ~]$ aws s3api create-bucket –bucket labtestrand –region us-west-2 An error occurred (IllegalLocationConstraintException) when calling the CreateBucket operation: The unspecified location constraint is incompatible for the region specific endpoint this request was sent to. Solution — [[email protected] ~]$ [[email protected] ~]$ aws s3api create-bucket –bucket labtestrand […]

Oracle to Postgres — Index Skip Scan

Posted 2 CommentsPosted in AWS, AWS Aurora

I have been working on Oracle to Postgres migration and it has been a fun ride. One of the recent encounters during migration was performance issue in Postgres for a query, actually quite a simple query. SELECT count(*) AS num_incidents FROM audit_cs acs INNER JOIN audit_changes ac ON acs.audit_change_id = ac.audit_change_set WHERE acs.object_id=$1 AND ac.path […]