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
feita há 8 meses201 visualizações
1 Resposta
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
ESPECIALISTA
respondido há 8 meses
profile picture
ESPECIALISTA
avaliado há 8 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas