Access to SQL

Report · Dec 14, 2006

Hi All..

I need some guidance on upsizing an Access 2003 databse to SQL server.
What do i need to run sql server locally so i can play around with it?
Any free solutions for testing locally would be great.

I have NO experience using SQl server and have only used Access in the past.

Thanks in Advance....

Andy

Report · Dec 14, 2006

SQL Server Express is free; SQL Server Developer Edition is cheap (about
$50). Either one will allow you to learn and test.

"Andy" <me@work.com> wrote in message
news:elrn8r$5r1$1@forums.macromedia.com...
> Hi All..
>
> I need some guidance on upsizing an Access 2003 databse to SQL server.
> What do i need to run sql server locally so i can play around with it?
> Any free solutions for testing locally would be great.
>
> I have NO experience using SQl server and have only used Access in the
> past.
>
> Thanks in Advance....
>
> Andy
>
>
>
>

Report · Dec 14, 2006

Thanks for that info Linostone
I'll down the Express version and have a play.....

Any other helpful info very much appreciated. I could do with a good book
(for beginners)

Thanks Again
Andy

"Lionstone" <HIDElionstone@HIDEhushmail.com> wrote in message
news:elrnua$6kd$1@forums.macromedia.com...
> SQL Server Express is free; SQL Server Developer Edition is cheap (about
> $50). Either one will allow you to learn and test.
>
>
> "Andy" <me@work.com> wrote in message
> news:elrn8r$5r1$1@forums.macromedia.com...
>> Hi All..
>>
>> I need some guidance on upsizing an Access 2003 databse to SQL server.
>> What do i need to run sql server locally so i can play around with it?
>> Any free solutions for testing locally would be great.
>>
>> I have NO experience using SQl server and have only used Access in the
>> past.
>>
>> Thanks in Advance....
>>
>> Andy
>>
>>
>>
>>
>
>

Report · Dec 14, 2006

On 14 Dec 2006 in macromedia.dreamweaver.appdev, Andy wrote:

> Thanks for that info Linostone
> I'll down the Express version and have a play.....
>
> Any other helpful info very much appreciated. I could do with a good
> book (for beginners)

You can still use Access as a front end, though there are some minor but
annoying differences in the SQL language. I Seem To Recall that the
handling of dates is one of them.

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

Report · Dec 14, 2006

Thanks Joe

As a SQL Server beginner, I wouldn't want to come against anything that
would potentially cause me any problems.
I could do with a good book or online tutorial, explaining how SQL Server
works compared to Access

Thanks
Andy

"Joe Makowiec" <makowiec@invalid.invalid> wrote in message
news:Xns98996C26DF191makowiecatnycapdotrE@216.104.212.96...
> On 14 Dec 2006 in macromedia.dreamweaver.appdev, Andy wrote:
>
>> Thanks for that info Linostone
>> I'll down the Express version and have a play.....
>>
>> Any other helpful info very much appreciated. I could do with a good
>> book (for beginners)
>
> You can still use Access as a front end, though there are some minor but
> annoying differences in the SQL language. I Seem To Recall that the
> handling of dates is one of them.
>
> --
> Joe Makowiec
> http://makowiec.net/
> Email: http://makowiec.net/email.php

Report · Dec 15, 2006

"Andy" <me@work.com> wrote in message
news:elrvhd$flk$1@forums.macromedia.com...
> Thanks Joe
>
> As a SQL Server beginner, I wouldn't want to come against anything that
> would potentially cause me any problems.
> I could do with a good book or online tutorial, explaining how SQL Server
> works compared to Access
>

I'm afraid it goes beyond a simple tutorial. Access can barely be called a
database and is definitely geared toward "power users" who at least can read
and follow directions. 🙂 SQL Server is an enterprise-class database system
that can be as big or small as you need it to be, but it's also far less
forgiving. It's self-tuning to the point where a developer can develop and
test without having to know much beyond standard SQL; having it running
long-term, though, requires a knowledgeable administrator. It's nowhere
near the work of keeping Oracle running, but there are some regular
maintenance tasks that need to be taken care of.

That being said, start by really learning SQL if you haven't already. If
you rely on "query builders" and other such GUI tools to write your queries,
then you're already in over your head. At a minimum, you should understand
data types, all types of joins, subqueries, derived tables, and have an
understanding of what each clause in the statement means (for instance, if
you're unclear on the difference between WHERE and HAVING, you're in
trouble). You can then pick up the basic T-SQL extensions as needed. After
that, visit www.sqlteam.com and www.sql-server-performance.com and start
picking up some tips. When you feel you have a good understanding of the
behind-the-scenes workings of SQL Server, then you can move on to books for
DBAs if you want to go that far. By this time, you'll at least understand
what the book is talking about. 😉