Solved

Upgrading SQL 2000 Standard to SQL 2005 Express

Posted on 2009-04-03
5
412 Views
Last Modified: 2012-05-06
I need to upgrade all our SQL servers to SQL 2005 but due to the recession we cant get full server licenses.  Is it possible to upgrade SQL 2000 Server Std to SQL 2005 Express?

Potential issues?

Limitations?

We have over 200 db's across 3 servers.
0
Comment
Question by:isiHelpDesk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 500 total points
ID: 24063214
There are significant limitations:

An instance can only use 1 CPU.
An instance can use a Maximum of 1GB RAM
A database cannot be larger than 4GB

You can look at a full feature comparison here:
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
0
 
LVL 29

Expert Comment

by:Nightman
ID: 24063320
Note: the CPU limitation is per die, not per core ... so if you ran SQL Express on a single quad core processor it would be able to use all four cores.

You still have the memory and database size limitation, though, which are significant.
0
 
LVL 2

Author Comment

by:isiHelpDesk
ID: 24064044
:( ok, well this puts a damper on things :(
0
 
LVL 2

Author Comment

by:isiHelpDesk
ID: 24144911
OK, if we decide to use SQL 2005 Standard, is the upgrade pretty smooth from SQL 2000?  I want to make sure it wont mess up customers existing databases.
0
 
LVL 2

Author Closing Comment

by:isiHelpDesk
ID: 31566385
Thanks for the heads up :)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question