SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
377 questions
SSMA DB2 to Sql Server partial schema migration
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
-
PrasannaSridharan-MSFT 96 Reputation points
2022-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.
Sign in to comment
Hi @PrasannaSridharan-MSFT so there's no way to remove foreign keys ?
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.