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

ROBERTO ALVES PEREIRA 20

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 !

PercyTang-MSFT 12,501 Reputation points Microsoft Vendor

2023-07-28T09:04:23.3433333+00:00

Hi,

You can take a look at the answers below. If it can help you, please accept it.
ROBERTO ALVES PEREIRA 20 Reputation points

2023-07-28T12:28:24.5933333+00:00

Sure, I will ask DBA to test this solution.
Actually, as this column was being used only to generate Unique ID (Seq number), we decided to recreate a new sequence (unique ID) on destination side (SQL server), but we'll test it as soon as possible.
GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-07-28T12:35:39.44+00:00

Sure Thanks @ROBERTO ALVES PEREIRA for the quick response.

Regards

Geetha
GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-08-03T15:50:35.3733333+00:00

@ROBERTO ALVES PEREIRA Did you got a chance to test?

Regards

Geetha

2 answers

Alberto Morillo 34,056 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.
Please sign in to rate this answer.
ROBERTO ALVES PEREIRA 20 Reputation points

2023-07-28T12:29:09.4166667+00:00

I will ask DBA to test it as soon as possible too.

Oury Ba-MSFT 19,581 Reputation points Microsoft Employee

2023-08-02T18:05:32.76+00:00

ROBERTO ALVES PEREIRA

Checking if you were able to check with your DBA. Please let us know if the above answer from @Alberto Morillo helpful.

If yes, please do mark as accept answer. Otherwise comment below if you have more questions.

Regards,

Oury
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-07-28T12:08:13.36+00:00

Hi, @ROBERTO ALVES PEREIRA

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
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

2 answers

Your answer