SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
SSMA DB2 to Sql Server partial schema migration
![](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(105.60000000000001, 7.000000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXK%3C/text%3E%3C/svg%3E)
Xavier Klausener
1
Reputation point
I'm trying to migrate only some schemas from DB2 IBMi into Sql Server.
I only want to migrate tables without any foreign keys or computed columns. Is this possible using Sql Server Migration Assistant for DB2 ?
Thanks
{count} votes
-
![](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(48, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
PrasannaSridharan-MSFT 96 Reputation points Microsoft Employee2022-08-19T05:07:42.243+00:00 Hello @Xavier Klausener - the full table can be migrated, there is no option to selectively migrate columns or keys.
-
Xavier Klausener 1 Reputation point
2022-08-19T06:59:47.807+00:00 Hi @PrasannaSridharan-MSFT so there's no way to remove foreign keys ?
-
![](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(83.2, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sriven Nookala 1 Reputation point2022-08-29T10:59:50.19+00:00 There isnt any way to remove foreign keys, computed columns while converting. You may however remove/disable the foreign keys in SQL server after synchronizing and perform the migration from SSMA.
Sign in to comment