Converting Access to SQL Server

[dave1167]

I am currnelty developing a web site which I hope will eventually generate a high traffic volume. Currently I am developing the back end Database in MS Access. Although if the web site takes I will have to convert to SQLServer 2000 whic h is the default Db my hosting compnay uses.
What I need to know is how easy is it to convert ?(their will be approx 7 dynamic pages which will link to the Db).

My reasons for not currently developing in SQL2000 is :

a) I know and understand MS Access extremely well I don't know SQLServer.
b) I don't own SQL Server2000 and also the hosting company charges me extra for running this. So I don't want to commit to SQL server until I am sure the web site will take off.

I also see that you can download a trial version of SQLserver 2000 which will give me a an unexpirable verison of enterprise manager, what does this give me? Or this now SQLServer express edition. Would I be able to develop on the free verison and then upload to my hosting provider?

Lots of questions thanks for your help in advance

:eek:
Many Thanks
Dave

[sirpelidor]

Hi,
when you use the term "convert", do you mean convert the database from *.mdb format to sql server? or do you mean "convert" your web application's connection from Access to SQLServer?

if (1), I think you can directly import the database from Access to SQL through enterprise manager

if (2) that depends if you follow N-Tier design ? if so, u need to alter your data access code tier, and you are done. the rest of the application shouldn't be affect nor care where the database come from

if (2) and not follow N-Tier design, you'll need to go through every pages which has sql statement, change your sql client from ODBC to SQL provider.

Hope this helps