Monday, August 3, 2009

The table does not exist in SQL Server

Symptom

When trying to migrate data using SSMA user may get the above error. When clicked on "Migrate Data", after entering the user name and password, it pops up "The table 'xxxxxx' does not exist in SQL Server. You must first convert the table and then load it into the database."

Cause

This error occurs when user tries to migrate the data before doing the ‘synchronize with the database’ operation.

Resolution

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. The table structure will not be created in the sql server database until you synchronize.

More Information

Article Id: KBO2SS1006

Applies to

SSMA 2005 for Oracle

SSMA 2008 for Oracle

1 comment: