locked
ssma from mysql error 22018 RRS feed

  • Question

  • we are using ssma 6.0 to migrate mysql to sqlserver 2012 by mysqlodbc 5.3.4

    when doing migrate data - for some tables we get

    [Gui: Info] [11956/1] [2014-10-02 10:35:29]: Starting data migration...
    [Gui: Info] [11956/1] [2014-10-02 10:35:33]: The data migration engine is migrating table 'otrs.article': > OTRS.dbo.article, 53529 rows total
    [Gui: Info] [11956/1] [2014-10-02 10:35:35]: ERROR [22018] [MySQL][ODBC 5.3(a) Driver][mysqld-5.1.51-community-log]
    [Gui: Info] [11956/1] [2014-10-02 10:35:35]:  Errors: ERROR [22018] [MySQL][ODBC 5.3(a) Driver][mysqld-5.1.51-community-log]
    [Gui: Info] [11956/1] [2014-10-02 10:36:03]: Table otrs.article data migration: 5495 rows processed...

    not all rows are migrated. checked data and could not see any specific characters/data

    is this mysql error / sqlstate / ssma error ????

    the text above is all we get in the logs...

    Thanks for all update/help

    best regards, Guy Przytula

    Thursday, October 2, 2014 9:11 AM

Answers

  • Hi Przytula,

    When we use SQL Server Migration Assistant  for MySQL to migrate MySQL to SQL Server, please note that  there are some basic steps as follows. For more details, you can review this blog.

    1. Create a MySQL migration project
    2. Connect to a MySQL database
    3. Create report of potential conversion issues
    4. Connect to SQL Server
    5. Convert schema
    6. Synchronize with database
    7. Migrate data

    According to your description, specific characters or data are not migrated successfully. I recommend you check the data type of these data, as some MySQL data types are not supported in SQL Server. SSMA cannot handle such conversion issues automatically, we need to manually change the data definition syntax before migrating them to SQL Server.

    For more details, please review the MigrateMySQLtoSQLServer2008 white papers which can be downloaded from the following link:
    http://www.microsoft.com/en-us/download/details.aspx?id=24662  .


    Thanks,
    Lydia Zhang


    Friday, October 3, 2014 2:57 AM

All replies

  • Hi Przytula,

    When we use SQL Server Migration Assistant  for MySQL to migrate MySQL to SQL Server, please note that  there are some basic steps as follows. For more details, you can review this blog.

    1. Create a MySQL migration project
    2. Connect to a MySQL database
    3. Create report of potential conversion issues
    4. Connect to SQL Server
    5. Convert schema
    6. Synchronize with database
    7. Migrate data

    According to your description, specific characters or data are not migrated successfully. I recommend you check the data type of these data, as some MySQL data types are not supported in SQL Server. SSMA cannot handle such conversion issues automatically, we need to manually change the data definition syntax before migrating them to SQL Server.

    For more details, please review the MigrateMySQLtoSQLServer2008 white papers which can be downloaded from the following link:
    http://www.microsoft.com/en-us/download/details.aspx?id=24662  .


    Thanks,
    Lydia Zhang


    Friday, October 3, 2014 2:57 AM
  • I too had this very same error and all my mappings/conversions were correct. Turns out I was using the ANSI MySQL ODBC driver rather than the Unicode one! See my post here
    Monday, November 3, 2014 10:22 AM