When using SQL Server Migration Assistant (SSMA) to migrate data from a Sybase/Access/Oracle database, you may get an error that is similar to the following after you click Migrate Data button and enter your user login credentials:
- The table <table name> does not exist in SQL server. You must first convert the table and then load it into the database
This error message generally occurs when the target table does not exist in the SQL Server database. This usually hapens occurs when you try to migrate data to SQL Server before completing the Synchronize with the Database operation.
After converting schema, you need to synchronize the table with the database before migrating the data. To do this right click on the SQL Server database in Metadata explorer and then choose Synchronize with database option. The table structure will not be created in the SQL Server database until you synchronize.
for other considerations.