MySQL Forums
Forum List  »  MySQL Workbench

Migration from Mysql 5.1 to 5.7. Case on view and routine objects changing
Posted by: Doug Thomson
Date: December 05, 2017 08:15AM

Trying to do a migration from Mysql 5.1 to 5.7. Having an issue when it comes to the Source Objects. The Table objects seem ok, but with some of the Routine objects the case (upper/lower) seems to be changed. For example the routine on the source server is called F_FULLNAME but WorkBench is picking it up as f.fullname and later on in the migration it will fail to create objects as it's looking for F.FULLNAME but it can't find it. Doing the opposite thing for f_address_line_1, changing it to F_ADDRESS_LINE_1 Just wondering if there's anything I should be looking at? Not doing it for all just some.

Options: ReplyQuote


Subject
Views
Written By
Posted
Migration from Mysql 5.1 to 5.7. Case on view and routine objects changing
32
December 05, 2017 08:15AM


Sorry, only registered users may post in this forum.

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.