SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 ?
Hello @Xavier Klausener - the full table can be migrated, there is no option to selectively migrate columns or keys.
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.