March 14, 2013 at 7:58 am
Hello Team,
We have created some new sql server, and have installed evalution version (SQL 2K8 Enterprise Evalution), we did created many DB on that and have also installed sharepoint too, now everything is working fine and we get green signal from our management to have this systems on production. Now we have licence version of Enterprise as well as Standard version licence on some machine. M
My doubt are as below :
1. Could we install SQL 2K8 STD on SQL 2K8 Enterprise version, vice versa ? If yes, is it going to affect my current settings and databases ?
2. Is it possible, without reinstalling we can input product key on evalution version to make it licence version ?
Thanks in advance,
Jitendra
March 14, 2013 at 8:05 am
It sounds like you are talking about a downgrade when you bring the databases into production.
The big question is really: Are you using any Enterprise-level features that aren't available in the Standard Edition? My recommendation would be to plan for some downtime, detach the databases you currently have and store them temporarily externally. Uninstall the Enterprise version, reinstall using the Standard version remembering to use the same instance names etc during the installation, copy the databases into the new software installation and reattach them.
This will mean you have a downgraded version of the SQL Server software with the same settings as you had before (minus any Enterprise features you may have had).
The mistake you made was evaluating with the Enterprise software. Had you evaluated with the Standard software, all you would have had to have done is type in the serial number for the license and everything would be good!
March 14, 2013 at 8:42 am
Hello Kevabug,
Thanks for quick reply,
Is it possible to add serial key after installation ? or we need to reinstall sql to just enter product key ?
March 14, 2013 at 8:48 am
You can enter the key during the installation. It is a part of the setup routine so you can't miss it! If you elect to install the evaluation version, then it is still possible to enter the key after the installation has been completed.
Like I mentioned before, the problem is that you have Enterprise software. Obviously that can't be activated using the key from the Standard version.
March 15, 2013 at 4:59 am
jitendra.padhiyar (3/14/2013)
Hello Team,We have created some new sql server, and have installed evalution version (SQL 2K8 Enterprise Evalution), we did created many DB on that and have also installed sharepoint too, now everything is working fine and we get green signal from our management to have this systems on production. Now we have licence version of Enterprise as well as Standard version licence on some machine. M
My doubt are as below :
1. Could we install SQL 2K8 STD on SQL 2K8 Enterprise version, vice versa ? If yes, is it going to affect my current settings and databases ?
2. Is it possible, without reinstalling we can input product key on evalution version to make it licence version ?
Thanks in advance,
Jitendra
The DMV, sys.dm_db_persisted_sku_features (http://msdn.microsoft.com/en-us/library/cc280724(v=sql.100).aspx) could help you determine if you have any Enterprise/Developer only features enabled before you attempt a downgrade.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply