Migration to SQL-Server

Posted on 2006-03-21
Last Modified: 2012-08-14
Can anybody help me with preparing a migration from  Jet to SQL-Server 2005.

* I want to use the upsizing wizard.
* I use MS Jet replication now.
* All tables already have unique keys with GUID fields.

When using a SQL-Backend:
* What problems will arise - what are common approches to handle these.
* Will DAO work? What about necessary OpenRecordset parameters.
* and, and, and.

I suppose there must be some manual out there in the Internet. I hope that these type of material will prevent me to post tons of questions here when running into these problems.
Question by:chriswies
    LVL 46

    Assisted Solution


    Check out
    "Access 2000 Upsizing Tools" White Paper Available in Download Center

    LVL 46

    Expert Comment

    LVL 7

    Accepted Solution


    There are a bunch of resources about migrating from Access to SQL Server. A good page to start on is

    Specific information about using the Upsizing Wizard is found here: as well as in the Access help.
    Even though those ressources talk about SQL 2000, the Upsizing Wizard is the same and all the information in the paper still appliy to SQL 2005.

    One special point for SQL 2005 Express: you will need to enable TCP/IP connection in order for Access to talk to SQL Server. This is off by default in the Expr.  Edition. You can configure this using the SQL Configuration Manager ( )
    Some more information if Access & SQL Server are not at the same machine:

    Nontheless, I would recommend using SSIS (former DTS) features to import the data into Yukon



    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now