upgrade from MS Access 2000 to SQL Server 2000 standard or 2008 Express?

Which is better for converting a growing 0.6GB MS Access 2000 database, we bought SQL Server 2000 Standard edition, but would SQL Server 2008 Express (free) be a better choice?

more ▼

asked Mar 14, 2011 at 04:40 PM in Default

avatar image

84 8 8 12

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

For me, I would go for the 2008 Express option because:
- it is supported
- it has many features that 2000 didnt
- data types (DATE, Geospatial etc)
- Windowed functions and CTEs
- Schemas
- reporting services with Report Builder 3
- OS compatibility going forward
- and others that I dont have in mind right now

OK, there are draw backs on database size (R2 has a 10GB limit) but if your database is as you say then this wont be an issue.

Use the link in Hakan's answer for SQL Express features and compare then with the features in SQL 2000 here http://msdn.microsoft.com/en-us/library/Aa175266 to see what you might miss out on.

more ▼

answered Mar 15, 2011 at 01:51 AM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

  • Thats true, I didn't notice it was SQL server 2000.

Mar 15, 2011 at 03:41 AM Håkan Winther
(comments are locked)
10|1200 characters needed characters left

Express is free and standard edition is not, but if the money is not an issue, you should go for the standard edition. You can compare the editions at http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

(hate auto correction in iPhone)

more ▼

answered Mar 14, 2011 at 11:46 PM

avatar image

Håkan Winther
16.6k 37 46 58

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 14, 2011 at 04:40 PM

Seen: 902 times

Last Updated: Mar 14, 2011 at 04:40 PM

Copyright 2018 Redgate Software. Privacy Policy