Conversion from Access to SQL Server - Assistance

Posted on 2011-04-26
Last Modified: 2012-05-11
Hey Experts! I am going to be migrating a client's back-end Access DB to SQL Server and know that code changes will be required, queries may be impacted, stored procedures and pass through queries may be recommended -- I wondered if there were a site to help me make sure I cover all my bases and to help me expedite the process. I have upsized the data a couple times and it all went in fine -- data is normalized -- But I've done this is the past and neglected to take notes on all that I had to do.

I appreciate any direction you may have for me.

Thanks a lot!
Question by:Ei0914
    LVL 2

    Accepted Solution

    LVL 21

    Expert Comment

    by:Alpesh Patel
    Import fulll Access file to SQL Server.

    Do changes in code appropriate with Query (IIF to Case)
    Connection (Connectionstring)

    You can create SP, trigger and functions.
    LVL 42

    Assisted Solution

    what is your access version and sql server version edition?


    How to convert an Access database to SQL Server

    Microsoft Access 97 Upsizing Tools

    How to Migrate from Access to SQL Server 2000

    sql 2005 and 2008Migration for Microsoft Access

    SQL Server Migration Assistant for Access (SSMA for Access)


    Author Closing Comment

    I knew I could count on the Experts! Thank you so much! Best, Eileen

    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

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    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