Migrating DB2 tables from IBM Public Cloud to SQL Server in MS Azure

ROBERTO ALVES PEREIRA 20 Reputation points
2023-07-27T17:32:08.81+00:00

I'm working on a project that is migrating thousands DB2 tables to SQL server in MS Azure using SSMA tool.
99,9% of tables were migrated with success, however, a couple of DB2 tables containing columns set as binary 'CHAR() FOR BIT DATA (13)' are not being converted to SQL server successfully.
Any suggestion to load those tables via SSMA tool ? Should i set something different on SSMA tool ? Any clue for SSMA not being able to load it from source (DB2) and store it in SQL server ?
Any comment or suggestions are welcome !

Azure Database Migration service
Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,341 Reputation points MVP
    2023-07-27T19:05:35.9366667+00:00

    On DB2, can you create a copy of those tables using binary data types where those binary can be converted to DB2 built-in data types (blob, binary_double, binary_float, binary_integer, long raw, rowid. etc) as mentioned here? Built-in data types that SSMA can easily convert from the copy table to Azure SQL. SSMA converts a blob (DB2 data type) as SQL Server varchar(max) data type, for example.

  2. GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
    2023-07-28T12:08:13.36+00:00

    Hi, @ROBERTO ALVES PEREIRA

    User's image

    I tried converting and migrating a table with the mentioned datatype. It is working on my side. Can you share some more details or the schema having an issue with?

    Regards

    Geetha

    0 comments