You get "The table <table name> does not exist in SQL Server" error when using SSMA

Article ID: 2019072 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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

Cause

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.

Resolution

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.

More Information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2019072 - Last Review: October 25, 2010 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server Migration Assistant 2005 for Access v4.0
  • Microsoft SQL Server Migration Assistant 2005 for Oracle v4.0
  • Microsoft SQL Server Migration Assistant 2005 for Sybase ASE v4.0
  • Microsoft SQL Server Migration Assistant 2008 for Access v4.0
  • Microsoft SQL Server Migration Assistant 2008 for Oracle v4.0
  • Microsoft SQL Server Migration Assistant 2008 for Sybase ASE v4.0
Keywords: 
KB2019072

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com