Upsizing from Access to SQL Server - eek!

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.

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

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