New to SQL Server

Question

New to SQL Server

home-1061070

Grasshopper

Points: 18
More actions
April 5, 2009 at 8:05 am

#384289

Hello
I am a secondary school teacher and I have written several systems using ASP and an MSAccess databse. One of these now has over 400 users and I really need to upgrade - I have been advised to go for ASP.NET and SQL Server but I don't really understand which version I need.
I have downloaded SQL server express onto my laptop but I read somewhere there is a 4Gb limit on express and my current db is 20Gb.
Do I need to upgrade to SQL Server 2008 for my laptop when this is only my developement environment and I will get a web host with 2008 for the real db?
How do I tranfer data from Access to SQL Server?
How do I upload data from my laptop to my new host. With Access I just copy 1 file across.
Sorry if these questions are obvoious but I can't spend thousands of pounds on SQL Server 2008 for my laptop and I can't work out what I should do.
Thanks
Sophie

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

I know that this will not be the real answer to your final deployment on a hosted server, but have you examined the availability of SQL Server 2008 DEVELOPER EDITION. Here in the U.S. it is available from Amazon.com for about $50. USD. It will allow you to do everything that the Enterprise edition can do. When purchased all you must keep in mind is that it can not be used in your production environment. It will therefore be a low cost development tool where you can learn, import your Access database and develope a completely new front end or keep your Access application as your front end with SQL Server as your data depository. In other words it will be a relatively inexpensive learning tool.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

wow ... msaccess with 20Gb data ??

also check "microsoft migration assistant for sqlserver" which if free at www.microsoft.com/Sqlserver/2005/en/us/migration.aspx

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

home-1061070 Grasshopper Points: 18 More actions · Answer 3

Ahh ah yes I have found it on Amazon Uk. The price is more to my liking.

Many thanks

home-1061070 Grasshopper Points: 18 More actions · Answer 4

yes well it is 20Gb for a reason. I teach about 500 students who do between 2 and 8 projects and each project has up to 107 records......plus all the other stuff I keep track of - the targets the predictions the actual results. You should see the statistics teachers are expected to produce these days! Every child matters.

I never intended it to reach that size!

I'm sorry for sounding a bit new but I found the microsoft website rather impenetrable on the subject of versions and pricing.

Many thanks for your help

Sophie

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 5

Hi

You should also have a look for the MSDN Academic Alliance (MSDN AA). I'm not sure if this is also available for teachers but it would be a low price (or maybe free) version of almost all Microsoft Tools. Starting point is:

http://msdn.microsoft.com/en-us/academic/default.aspx

Greets

Flo