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

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ