March 3, 2014 at 12:20 am
Hi All,
Can we upgrade database from SQL Server 2005 Enterprise edition to SQL Server 2012 Standard Edition?
Thanks in advance.
March 3, 2014 at 4:47 am
You can't. According to microsoft ( http://technet.microsoft.com/en-us/library/ms143393.aspx%5B/URL%5D) if you upgrade enterprise edition, you can ugragde it only to enterprise or Business Intelligence editions.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 3, 2014 at 8:32 am
fmaruf (3/3/2014)
Hi All,Can we upgrade database from SQL Server 2005 Enterprise edition to SQL Server 2012 Standard Edition?
Thanks in advance.
Could you tell us why you are trying to move from Enterprise to Standard ..
---
SQLBuddy
March 3, 2014 at 9:03 am
If you're trying to save money on licensing, I don't believe you an upgrade. However you can purchase 2012 Standard and "migrate" to this version.
March 3, 2014 at 11:34 pm
Thanks all for your valuable reply.
Yes, we are planing to go for Standard edition because of Licensing cost.
Can we backup database from SQL Server 2005 Enterprise edition and use same Database on SQL Server 2012 Standard edition?
March 4, 2014 at 10:08 pm
Yes, you can stand up a Standard Edition SQL and migrate your Enterprise database to this instance. However, please make sure to confirm your application or SQL won't require any of the Enterprise only features (online indexing etc...)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply