access >> sql

Report · Jun 28, 2006

hi everyone,
have been happily developing using iis, asp and access databases, but feel now i should move on to asp with an sql database.
would you know roughly what i would need to do/bear in mind to make the jump?
many thanks

Report · Jun 28, 2006

Hi,

What database are you planning to move to? The 3 I would contemplate are
MySQL which is free and very good, Oracle which is definately not free
(quite the opposite) but is the biggest and the best out there but demands a
very, very steep learning curve and there's SQL Server from Microsoft which
is very, very good. It's probably the second biggest behind Oracle and while
not quite as complicated to use, is still a vast piece of software to get to
know well. It offers a great array of built in tools, many of which have
wizards that help when you're new and has a far more 'hand-holding'
approach.

I would suggest SQL Server 2000 or 2005 but I am a little biased as I work
with it on a daily basis and it is a very good product. Don't get me wrong
though, SQL Server (or any Server based DB) is a big, big jump from Access,
even using it on a basic level. These are professional tools built for
professionals and you will have a lot to learn but it will definately be
worth it.

If you are into web/eCommerce development and want to expand your knowledge
then this is the only way to go. It could open up a whole new world for you
(it did for me a few years ago when I was in the same position as yourself)
and will give you far greater potential for your programming.

Best advice I can give:

Get lots of books
Use the wealth of advice on the Internet
Ask lots of questions on forums like this
Get stuck-in and stick to the task. It WILL be worth it

Pat.

"Fido" <webforumsuser@macromedia.com> wrote in message
news:e7u2ga$6m5$1@forums.macromedia.com...
> hi everyone,
> have been happily developing using iis, asp and access databases, but feel
> now
> i should move on to asp with an sql database.
> would you know roughly what i would need to do/bear in mind to make the
> jump?
> many thanks
>

Report · Jun 28, 2006

Hi yea, I go with that too,

I used access for a long time, I had to upgrade but on going to SQL server
found that my isp charged an arm and a leg, luckly they also offered mySql
and it is very very good, If your not to scratch in the sql area and were
looking for some type of gui to help create the db I found
http://sqlmanager.net/ was very good.

regards

kenny

"Fido" <webforumsuser@macromedia.com> wrote in message
news:e7u2ga$6m5$1@forums.macromedia.com...
> hi everyone,
> have been happily developing using iis, asp and access databases, but feel
> now
> i should move on to asp with an sql database.
> would you know roughly what i would need to do/bear in mind to make the
> jump?
> many thanks
>

Report · Jul 06, 2006

thanks very much for the very useful information. i'll be using that for sure.
one more thing if i may ... currently i run iis on my web server, im sorry if this is a terrible questions but ive been kinda wondering about it ... could i load apache on my web server too and use php/mysql, and then other times use asp on iis etc ? is that even physically possible or it is something that just plain wrong !

thanks pete.