SQL Newbie

[scouser]

Guys I will shortly be installing SQL 2005 in a production environment to house my companies new system.

I wanted to get familiar with it prior to 'Go Live' .

I was looking to install SQL 2005 in a test lab environement.

I have an Access database with around 20 tables, 30 queries etc.... As a project I was looking to move this into SQL (I presume I would still use access forms at the front end?)

So to get to my point. I am sure many of you have done this. Can anyone offer some tips to get me started? Point me in the direction of a good article?

Many Thanks,
Phil

 

[pbaldy]

You are correct that forms and such will stay in Access. You can use the upsizing wizard to push the tables to SQL Server (I would leave it as an MDB, not converting to an ADP, but that's me). It has worked pretty well for me. Make sure you have keys on your tables before upsizing; they will not be updateable without.

Your application will probably work as is at that point, though you should spin through the whole thing to be sure. You can then start getting familiar with stored procedures, views, etc on SQL Server. They will provide you with some tools to increase performance as you incorporate them.

 

[burrcm]

The Migration Assistant for Access is a brilliant tool - well worth a look.
http://www.microsoft.com/downloads/...B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en

Chris B

 

[scouser]

Thanks

Thanks guys.

It is more of a training tool. I want to have a greater understanding of SQL so I thought what better way than to import a database then play about with some meaningful data. As you rightly say I can then start scratching my head over stored procedures etc......
Thanks,
Phil.

 

[tehNellie]

There are a bunch of sites out there that have some great articles, you'll love what you can do in SQL server compared to Access. http://sql-server-performance.com is one that springs immediately to mind as is http://www.databasejournal.com

Getting an existing database migrated into SQL is a good way to start imo. Access can continue to drive the DB, initially at least, while you get your head around all the fun and funky stuff that SQL server can do.

 

[scouser]

Thanks

Thanks for the links. Looking forward to the challenge.
Phil.