Posted by NickName on 06/23/06 19:25

Thanks. Would be interested in reading M. Chipman's writings on "don't
use the wizard", did key word search for it to no avail.

Erland Sommarskog wrote:
> 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: Deleted "old" transaction logs = (no items) in EM. How to recover?
• Prev in forum: Re: Creating Cursor from Stored Procedure
• Thread view: Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?

[Reply to this message]