SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot eStudio's Avatar
    Join Date
    Dec 2001
    Location
    NE Texas
    Posts
    153
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access to SQL - Help a Newbie

    I've built a site using Access and it has turned into an extremely busy site that needs to be transferred to SQL in order to handle the load. I'm sure nobody has time to explain exactly how to transfer the db to SQL so any help would be greatly appreciated.

    Online references or whatever...

    I don't know anything at all about SQL so please be patient.

    TIA,
    Donna

  2. #2
    SitePoint Addict
    Join Date
    Aug 2000
    Posts
    248
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There are 3 ways:

    1) Use the built in Access upsizing Wizard.

    2) Use the Built in SQL server DTS data import Wizard.

    3) Replicate the tables by hand and then import the data with DTS in SQL Server.

    Depending on how you wrote your SQL for Access you MIGHT run into some code that you have to modify a bit.


    HTH


Bookmarks

Posting Permissions

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