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: KBS2SS1004

Applies to
• SSMA 2005 for Sybase
• SSMA 2008 for Sybase

No comments:

Post a Comment