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 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南