question

shenghuani avatar image
0 Votes"
shenghuani asked ·

Error migrating Oracle table to SQL Server 2012

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'.

not-supported
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

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)


10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.