• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

migrating from sql standard to enterprise

Hi Folks,

 If you wanted to upgrade from standard to enterprise in sql 2008 Is that pretty seamless (like upgrading sql versions)?

1 Solution
Daniel WilsonCommented:
Should be even easier as SQL 2008 Enterprise will only increase the capabilities over Standard.  There will be no new keywords or other surprises ... as one always suspects between versions.
david_32Author Commented:
so how is it done?
Raja Jegan RSQL Server DBA & ArchitectCommented:
You wont see any differences as a Developer
You will see more hardware (CPU) support in Enterprise edition which would be helpful for the Database Administrator.
Mark WillsTopic AdvisorCommented:
Using command line setup , In SQL Server 2005 you use /SKUUPGRADE=1  and in 2008 now use /ACTION=editionupgrade

But first backup everything... Use the upgrade advisor tools...

Have a look at : http://msdn.microsoft.com/en-us/library/ms144259.aspx
david_32Author Commented:

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now