SSMA migrate data to different schema in SQL Server

vivek pothagoni 21 Reputation points
2023-04-11T13:35:52.3133333+00:00

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?

SQL Server Migration Assistant
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
SQL Server Other
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 47,436 Reputation points
    2023-04-11T14:06:24.0266667+00:00
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.