SQL 2000 to 2008 upgrade : EE vs. SE

Question

SQL 2000 to 2008 upgrade : EE vs. SE

Steven McKenna-317587

SSC Enthusiast

Points: 106
More actions
October 14, 2008 at 8:56 am

#199364

We are currently running SQL 2000 Enterprise edition on all our servers. When we upgrade to SQL 2008, do we need to upgrade to the same Enterprise version or can we use the Standard ?
What functionality will we lose?

Viewing 5 posts - 1 through 4 (of 4 total)

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

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

Here is the feature comparison

http://download.microsoft.com/download/2/d/f/2df66c0c-fff2-4f2e-b739-bf4581cee533/SQLServer%202008CompareEnterpriseStandard.pdf

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

If you do an in-place upgrade, you cannot downgrade the Edition.

If you install a new instance on the same or a different server, you can install the standard edition and you will be able to attach or restore your existing databases. If you have used any enterprise-level features, you will have issues.

Steven McKenna-317587 SSC Enthusiast Points: 106 More actions · Answer 3

Steven McKenna-317587

SSC Enthusiast

Points: 106

October 14, 2008 at 10:50 am

#884776

Thanks to you both for the link and the data!

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 4

Michael Earl-395764

SSC Guru

Points: 53873

October 14, 2008 at 10:52 am

#884780

You are welcome - from both of me.