Forums
This topic is locked
How do I upgrade an access site to sql server?
Posted 20 years ago
1
has voted
20 years ago Mat Burhouse posted:
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
Replies
Replied 20 years ago
20 years ago Vincent Fischer replied:
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.
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.
Replied 20 years ago
20 years ago Mat Burhouse replied:
Thanks for that! I've now got a copy of dev so will dive in and have a go.
Thanks
Thanks