Upsizing Wizard - Error

W

Weste

I am trying to use the upsizing wizard to upsize an Access 2003 database to
SQL Express 2005. I keep receiving the following error on all the tables.

Table was skipped or export failed.

It doesn't give me any additional details. Does anyone know what causes
this error and how to fix it? Thanks.
 
S

Sylvain Lafontaine

I'm not sure but it's possible that the upsizing wizard is not able to work
against SQL-Server 2005, only with SQL-Server 7 & 2000. Another possibility
would be that the upsizing wizard is not able to connect to the Sql-Server
using the credential (login, password, protocol) that you have provided.

Try with the SQL Server Migration Assistant for Access instead:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

In both case (upsizing wizard or the SSMA); don't expect to much. There is
also a newsgroup dedicated to the upsizing process:

m.p.access.sqlupsizing
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top