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:47:09

Hi Mat

There's an Upsizing wizard in Access that can be used for this, probably your best bet.

Your connection string will need to be modified to have the site point to the SQL server version.

Regarding code changes, most of what you do in access will be the same for SQL, but you might find you have a few bits to change, you just have to test your pages.

Check these out:

www.sqljunkies.com/How%20To/BD909D1E-3EA1-4323-889E-5E3A5415B977.scuk

support.microsoft.com/default.aspx?scid=kb;en-us;Q237980



Digga

Sharing Knowledge Saves Valuable Time!!!

Hi Digga, thanks for that, that's certainly a relief!

Do you know what version of SQL Server I'll need to buy/install?

Thanks

Get Developer edition, it allows developers to build any type of application on top of SQL Server. It includes all of the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment - think its about £40 from Amazon

upsizing the database... check out this link msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/sqlbackend.asp will explain the issues you'll encounter upsizing and how to avoid the pitfalls.

Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]

Thanks Simon!