This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 63%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Everyone,
Greetings! Request your expert advice and support.
We need to migrate the Tables from Source AS400 DB2 to Target MSSQL 2022 server.
Following steps has been followed by us -
Installed SQL Server Migration Assistant software for DB2, Configured source database connection as DB2 for I AS400, Target to MSSQL database. We have performed convert schema option for existing schema in AS400. When we execute the downloaded script from SSMA it is throwing error for Primary keys on all the tables in schema. Tables are created in target MSSQL server without primary keys and ignored.
Problem is we are not able to match and create automatically Primary key constraints using SSMA tool from source AS400 to target MSSQL.
Please assist.
Thanks in advance.
Add an example of a failed PK create statement and error message to your question. That may better help others answer your question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 66%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIA%3C/text%3E%3C/svg%3E)
As above, we are getting the table creation sql script from SSMA, where on the top, column is defined as NULL and below alters statement is running where primary key has to be created on NULL column. Here we are getting error as "Primary key constraint can't be created on NULL column" .. Please advise on this.
Fyi - Please find above my colleague (Indrasekher) comment along with SQL script.