Posted by Erland Sommarskog on 06/23/06 11:07

MGFoster (me@privacy.com) writes:
> Use the MS Access Upsizing wizard (Tools > Database Utilities > Upsizing
> wizard). It will convert all relationships, PKs, FKs and indexes from
> the Access DB to the SQL DB.

As I have never worked with Access, I don't have any experience of the
upsizing wizard. However, I have seen Mary Chipman who has been an MVP
for both Access and SQL Server (today she is an MS employee), say several
times "don't use the wizard". The two products are so different that the
best way to convert is hard work where you make a thorough redesign of
the application. Using the upsizing wizard leads to an Access database
that runs in SQL Server, but which maintains many of the problems with
Access.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: The identifier that starts with...is too long. Maximum length is 128
• Prev in forum: Re: Comparison operator in Select list
• Thread view: Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?

[Reply to this message]