Access to SQL - Help a Newbie

[eStudio]

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

[alexming]

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