AWS SCT conversion from MySQL to Postgre, Objects are converted to lowercase

0

Hi Team,

I would like to get help on conversion from MySQL to Postgre with SCT tool, I get errors on schema conversion like all column name is camel case in Mysql whereas it is getting converted to lowercase in postgre schema, which will not be applied to columns. Many schemas are not not supported with automatic conversion but is their a way to verify the manual conversion of schema?

Suganya
asked 8 months ago187 views
1 Answer
0

Hi Suganya.

Related to handling manual conversions, you could run an assessment report to evaluate how much manual conversions you need. Per the documentation:

The assessment report includes a list of items that can't be converted automatically to the database engine of your target Amazon RDS DB instance. For each item that can't be converted, there is an action item on the Action Items tab. You can respond to the action items in the assessment report in the following ways:

  • Modify your source database schema.
  • Modify your target database schema.

Now, I don't believe the assessment report will validate any manual conversion you add, however, as you make modifications to either source or target schemas, you can run the report and see how much more or less manual modifications are needed.

I hope this helps.

profile pictureAWS
EXPERT
answered 8 months ago
profile picture
EXPERT
reviewed 8 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions