November 21, 2011 at 6:54 am
How to upgrade sql server 2008 Express to sql server 2008 standard editon ?
Already running 2 databases in express editoin..?
Plese give tips what are steps follow to updrade?
Thans
jeri
November 21, 2011 at 6:59 am
you could backup\restore or detach\attach the databases to a standard edition install of SQL, or a google search bought this up:
---------------------------------------------------------------------
November 21, 2011 at 7:02 am
so, no need to run update advisor ?
November 21, 2011 at 7:05 am
no, you are not going up versions of SQL (e.g. sql2000 to sql2008)
---------------------------------------------------------------------
November 21, 2011 at 7:05 am
You're not upgrading in that sense. For the upgrade advisor you need to change the version (2008 to 2008 R2), not the edition (express, standard, enterprise).
November 21, 2011 at 7:14 am
Edition upgrade of 2008 R2 is quite different from what we used to do in SQL Server 2005, where we have to start installer from command prompt by passing the parameter SKUUPGRADE=1. In 2008 R2 there is no need to start installer from command prompt. Now we have a Edition upgrade option in 2008 R2 installer, under Maintenance tab.
Just wondering, this question should be in SQL server 2008 forum
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
November 21, 2011 at 7:19 am
I understand...
Thanks you lots..
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply