question

nkhurmi avatar image
0 Votes"
nkhurmi asked ·

Getting error while trying to migrate data to Azure SQL Database from Oracle using the "SSMA for Oracle" tool

I am using the "SSMA for Oracle" tool to migrate Oracle databases to Azure SQL Databases. I am able to migrate the schemas. But I am getting the below error while migrating the data:

Error occurred while inserting table information into the Data Migration Auxiliary table. Reason: Invalid object name 'WIMS_ST.o2ss.MSSsmaDmTables'

I have already followed this link and all the steps in it without any success: Error Migrating Data Error occurred while...

Has someone else also faced this issue recently? Can you please provide some pointers. Any log files etc. I should be checking or any configurations I may be missing.

sql-server-migration-assistant
10 |1000 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

pituach avatar image
0 Votes"
pituach answered ·

Good day

The QnA forums (where we are now) currently supports only the products listed in right-hand pane. This question does not related any of these. It is better to reach out in dedicated forums over here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlservermigration





It is very important to quote accurately word-by-word, to allow us (and you) to search the issue online. Make sure you do so when you re-ask the question.

According to your description you are getting the error:

"Error occurred while inserting table information into the Data Migration Auxiliary table. Reason: Invalid object name"

Notice that you have "the" in your error while the following error message is the one that you can find online (without the "the"). I assume that you did not quoted accurately

"error occurred while inserting table information into data migration auxiliary table. reason: invalid object name"





Anyhow, please close this thread and move the discussion to the right forum.




· 2 · Share
10 |1000 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.

Sure Pituach, I will close this thread and post the issue on the link you provided.
Also I will explain the error description more.

Thanks for your suggestion.

0 Votes 0 · ·

You are most welcome @nkhurmi

0 Votes 0 · ·