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
질문됨 8달 전201회 조회
1개 답변
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
전문가
답변함 8달 전
profile picture
전문가
검토됨 8달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인