Hi Guys, I was wondering if anyone can explain the steps involved in upgrading a Dreamweaver ASP site that uses an ACCESS database to use SQL Server.

I've been building sites with access for a few years now but the time has come to start using something more robust and convert some existing sites. The thing is I haven't got a clue where to start!

Can anyone explain:
1. What version of SQL Server will I need to run on the pc I use as a testing server
2. My sites are all ASP/VB mainly using dreamweaver/some hand coding/some dmxzone extensions - will I have to make many changes to my code?
3. Anything else you think I need to know

Thanks in advance!

Edited by - ruse on 13 Dec 2004 09:37:45

Edited by - ruse on 13 Dec 2004 09:47:31

I use SQL Server 2000. You can get a dev copy pretty cheap.

2. If you developed them right, the only change you should have to make is to the datasource, and possibly some tweeks on the SQL.

3. make sure your hosting provider supports SQL Server.

Thanks for that! I've now got a copy of dev so will dive in and have a go.
Thanks