Article ID: 2019072 - View products that this article applies to.
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:
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.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2019072 - Last Review: October 25, 2010 - Revision: 2.0