Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

2008R2 Developer versus Standard Editions--how to convert Expand / Collapse
Posted Wednesday, August 18, 2010 1:05 PM


Group: General Forum Members
Last Login: Wednesday, August 17, 2016 1:55 PM
Points: 148, Visits: 396
I've got a situation where an employee accidentally installed the developer edition of SQL Server 2005. We discovered this when we went to upgrade to SQL Server 2008 R2. The only upgrade path he could find was 2005 developer to 2008 R2 developer. We have a license for standard; we just don't know how to convert it. Can anyone help? Is our only option to un-install/re-install? My concern is that we are running the db side of Sharepoint on that box and I'm not certain if just re-attaching those db's to the newly installed instance will work or not. Thoughts? Help?
Post #971395
Posted Wednesday, August 18, 2010 2:35 PM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 3, 2016 3:17 PM
Points: 373, Visits: 644
This may or may not work. Typically, each edition adds something to the DB that cannot be used by a lower edition. MS says they are required by the additional functionality, but I can't confidently vouch for that.

If you try and attach the DB to 2008 R2 Standard and it says you can't, then I would script out the DB and table schemas including PKs, IDXs, etc. The use the Export/Import Wizard to tranfer the data between versions.

There may be a better way to do this, but this is how I have done it since 7.0.

Maybe someone else has an easier idea.
Post #971480
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse