SQL Server 2008 R2 Edition Differences
My company wants to upgrade from SQL Server 2008 R2 Express Edition with Advanced Services to the 2008 R2 Standard Edition. Before making any purchases, I just want to verify a few things:
1) The Dell server is running Windows Small Business Server 2011. Will the "SQL Server 2008 R2 Standard Edition for Small Business" qualify as a valid edition upgrade? I would normally assume it would, but given the cost of this product, I don't want to make any assumptions.
2) Besides price, what's the difference between the Standard Edition and the Standard Edition for Small Business?
1) The Dell server is running Windows Small Business Server 2011. Will the "SQL Server 2008 R2 Standard Edition for Small Business" qualify as a valid edition upgrade? I would normally assume it would, but given the cost of this product, I don't want to make any assumptions.
2) Besides price, what's the difference between the Standard Edition and the Standard Edition for Small Business?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the helpful information. Based on the comments, it seems that I can either purchase SQL Server 2008 R2 Standard Edition for Small Business, or purchase the Windows Server 2001 Premium Add-on.
My preferred goal is to upgrade the current edition... not to backup the DB, remove the Express edition, install the new edition, and restore the DB. With the SQL SBS setup, I should be able to upgrade the existing edition. Will I be able to upgrade the edition with the Premium Add-on as well, or will I have to remove the Express edition first?
My preferred goal is to upgrade the current edition... not to backup the DB, remove the Express edition, install the new edition, and restore the DB. With the SQL SBS setup, I should be able to upgrade the existing edition. Will I be able to upgrade the edition with the Premium Add-on as well, or will I have to remove the Express edition first?
ASKER
Thank you for all of the input. I purchased the SQL Server SBS edition.
A key difference between these two editions of sql, is that normally SQL and Exchange don't work well together on the same box. There are subtle changes to each for SBS so they will 'play nicely'.
HTH
David