Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Austin, Texas
    Posts
    1

    Unhappy Unanswered: Upsizing Access 2000 to SQL

    I'm going to try and upsize my database to SQL and I know that it would be a lengthy message to ask someone to help me with it.

    Instead, I'd like to ask if anyone can direct me to a website that has some indepth white sheets for an idiot-type person.

    Anybody know of a good place?

    Thx!

  2. #2
    Join Date
    Sep 2002
    Location
    MA
    Posts
    24

    Post

    Hey Bill,

    Im actually going through the process now. (Access Jet Engine just doesnt seem robust enough to meet our needs).

    Here's some great articles and white papers I just finished reading this evening:

    15 Steps to convert access to SQL Server
    http://www.sqlmag.com/articles/print.cfm?articleid=6133

    Beyond the Upsizing Wizard
    http://www.sqlmag.com/articles/print.cfm?articleid=6132

    Using the Access 200 Upsizing Tools
    http://www.assetnow.com/index.cfm/12...f/Upsize00.pdf

    Using the Microsoft Access 2000 Upsizing Tools with SQL Server 7.0
    http://msdn.microsoft.com/library/de...l/upsize00.asp

    Also check out these tools (havnt played with this myself yet):
    Access 200 and SQL Server Readiness Update
    http://office.microsoft.com/downloads/2000/Accsql.aspx

    The largest question I have now is do I upsize with the tool or use SQL's Data Transformation Services to recreated tables on the SQL server (there's plus and minus to each - see articles). I would love to hear other thoughts on this.

    G luck! (We are going to need it by the look of things).

    Tim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •