stracy2 (@stracy2)

Forum Replies Created

Viewing 1 replies (of 1 total)

  • stracy2
    Participant

    @stracy2

    As Robin pointed out (thank you), “My SQL Workbench” is likely the tool or at least a starting tool. I’ve tried its “Migration Wizard” going from a MS SQL database, but unfortunately the wizard errors out on MS ntext fields that contain 4 byte unicode characters (the error is “Inserting Data: Incorrect string value:” on the MySql side) despite both src and dst database fields having utf8mb4 as the character set, and even ensuring all of MySQL database connections are utf8mb as per here.

    Since it is not too practical to try and filter out the offending 4 byte unicode chars, so as an alternative now I’m trying saving the src data to CSV and importing CSV on the MySQL side – but apparently the CVS libraries disagree on encoding/decoding – the dst table ends up with more records than the source, not sure who is a fault.

Viewing 1 replies (of 1 total)