Migration- Table name are not correct and truncated
Hi,
I want to do database migration from MSSQLServer to mySql. some tables in MSSQL have a long name and when I migrate these tables it seems their names are truncated in mysql.
for example:
in MSSQL "CommonProviderSystem_Provider_ProviderTypeProviderOptionProviderDataValue" table will change to "CommonproviderSystem_Provider_ProviderTypeProviderOptionProvid1" in MySql
it's worth to mention that I've changed the source code of mysql and set 128 instead of 64 for NAME_CHAR_LEN variable so I can add manually a new table with a long name in workbench but not in the migration process.
how can I fix this?
Thanks in advance for any help.
Regards,
Zohreh
Subject
Views
Written By
Posted
Migration- Table name are not correct and truncated
1355
March 27, 2015 08:20AM
392
March 30, 2015 01:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.