This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(137.6, 27%, 23%)' 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)
I tried to migrate an Oracle table to SQL Server 2012 using SQL Server Migration Assistant. I followed the instructions:
In the Oracle Metadata Explorer, convert the Oracle Schema to Microsoft SQL database objects.
In the SQL Server Metadata Explorer, synchronize the changes with SQL Server.
In the Oracle Metadata Explorer, start to migrate the data.
But I still got error:
error occurred while inserting table information into data migration auxiliary table. reason: invalid object name 'mydatabase.o2ss.msssmadmtables'.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
QnA currently supports the products listed in right-hand pane (more to be added) Better to reach out to subject matter experts in dedicated forums over here.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlservermigration
(please don't forget to mark helpful replies as answer)