SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
We want to migrate COTS product data from Oracle DB to SQL Server, and we are using the SSMA tool. However, the Source schema is ABCD, and in the target, it is ABCD.dbo. Is there an option in the SSMA tool to migrate data to a different schema?
See https://learn.microsoft.com/en-us/sql/ssma/oracle/mapping-oracle-schemas-to-sql-server-schemas-oracletosql?view=sql-server-ver16 for how to modify the target schema.