Oracle to MSSQL migration error 'The table xxx doesnot exist in target'

Question

I am trying to convert and migrate an Oracle schema to MSSQL server. At the last step, migrating data, I get the error message:

The table [MYDATABASE].[MYSCHEMA].MYTABLE] doesnot exist in target. You must first convert the table then load it into the database.

This error message appears for each table in my schema.

Can someone explain what is happening and what I need to do to get past this?

Answer 1

Are you tries to migrate the data before doing the ‘synchronize with the database’ operation?

If Yes,

This error message generally occurs when the target table doesn’t exist on SQL server database. After converting schema, you need to synchronize the table with the database before migrating the data.

To do this you right click on the SQL Server database in Metadata explorer and click “Synchronize with database” menu.

Note: Table structure will not be created in the SQL server database until you synchronize.