Micorosft SQL Server migration assistant errors

emanuele gemelli 1

Hi everybody,
I'm trying to migrate a DB2 database to SQL Server using Microsoft SQL Server Migration assistant.
After I run the report, I see some errors without any suggestion to fix them.

Have you already used this tool?
I have already read Microsoft webpage without any help.
Do you have any suggestions?

CathyJi-MSFT 22,201 Reputation points Microsoft Vendor

2021-03-26T06:33:28.587+00:00

Hi @emanuele gemelli ,

Any update for this thread? Did the replies could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

2 answers

CathyJi-MSFT 22,201 Reputation points Microsoft Vendor

2021-03-22T03:17:41.573+00:00

Hi @emanuele gemelli ,

> After I run the report, I see some errors without any suggestion to fix them.

The Assessment Report window shows the results of the conversion of database objects to Transact-SQL syntax. The Error List pane shows error, warning, and informational messages.

What the error message that you got? Could you share them to us for analysis?
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.
emanuele gemelli 1 Reputation point

2021-03-22T12:24:27.06+00:00

DB22SS0083 identifier Mx06 cannot ne converted because it was not resolved

The main problem is an Add constraint not null.. do you know how I can convert it?
Thanks
Please sign in to rate this answer.
Alexander Ivanov 491 Reputation points

2021-03-22T15:47:19.493+00:00

Hello,

SQL Server supports NOT NULL constraints - simply mark your column as NOT NULL or issue an ALTER table ALTER COLUMN column <type> NOT NULL. There is probably more to it than you have shared with us, as standard "not null" constraints should be automatically converted. Can you share:

What version of SSMA you are using

DB2 version

Original SQL definition of the table that is causing issues

SQL text that SSMA produced

Feel free to reach out to us using Help -> Feedback option within the tool.

Regards,
Alex.
Sign in to comment

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

Share via

Micorosft SQL Server migration assistant errors

2 answers

Your answer