Upsizing from Access to SQL Server - eek!

Report · Feb 19, 2007

Ok - I've built quite a few dynamic sites using DW and Access, but the site
i'm currently working on requires Microsoft SQL Server for the database.
The site is almost complete and is written in Classic ASP.

Can anyone point me in the right direction, tutorials, crash course, etc to
get me up to spped with the task?
Would my ASP code need changing at all?

Thanks in advance
Andy

Report · Feb 19, 2007

On 19 Feb 2007 in macromedia.dreamweaver.appdev, Andy wrote:

> Ok - I've built quite a few dynamic sites using DW and Access, but
> the site i'm currently working on requires Microsoft SQL Server for
> the database. The site is almost complete and is written in Classic
> ASP.
>
> Can anyone point me in the right direction, tutorials, crash course,
> etc to get me up to spped with the task?
> Would my ASP code need changing at all?

As Far As I Know - the only place you'll run into a problem is that there
are a few differences in SQL between Access and SQL Server. There are a
number of sites with information:

http://www.google.com/search?q=differences+access+sql+server

The first result (at aspfaq.com) looks good.

But you shouldn't have any problem with the ASP code. I think you'll
like the change from Access to SQL Server.

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/email.php

Report · Feb 19, 2007

Hi Joe

Thanks for the help -
Andy

"Joe Makowiec" <makowiec@invalid.invalid> wrote in message
news:Xns98DC757E87EFAmakowiecatnycapdotrE@216.104.212.96...
> On 19 Feb 2007 in macromedia.dreamweaver.appdev, Andy wrote:
>
>> Ok - I've built quite a few dynamic sites using DW and Access, but
>> the site i'm currently working on requires Microsoft SQL Server for
>> the database. The site is almost complete and is written in Classic
>> ASP.
>>
>> Can anyone point me in the right direction, tutorials, crash course,
>> etc to get me up to spped with the task?
>> Would my ASP code need changing at all?
>
> As Far As I Know - the only place you'll run into a problem is that there
> are a few differences in SQL between Access and SQL Server. There are a
> number of sites with information:
>
> http://www.google.com/search?q=differences+access+sql+server
>
> The first result (at aspfaq.com) looks good.
>
> But you shouldn't have any problem with the ASP code. I think you'll
> like the change from Access to SQL Server.
>
> --
> Joe Makowiec
> http://makowiec.net/
> Email: http://makowiec.net/email.php

Report · Feb 19, 2007

As long as you aren't using stored procedure, date/time functions in your sql queries, and all your database information such as tables/columns/PK's and FK's are the same you should be okay. Just change the connection. And make sure you have the correct data types.