I would like to upgrade my SQL Server 2005 Express instance which is installed using this command:
SQLEXPR.EXE/qs /action=INSTALL /IACCEPTSQLSERVERLICENSETERMS
/FEATURES=SQLEngine /INSTANCENAME=ABCD
/SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SECURITYMODE=SQL
/SAPWD=abc#Wd1234 /TCPENABLED=1 /NPENABLED=1
but when I am trying to upgrade the server instance ABCD
with this command
SQLEXPR_x64_ENU.exe /q /ACTION=upgrade /INSTANCENAME=ABCD /IACCEPTSQLSERVERLICENSETERMS=1
the instance ABCD
is not upgraded to SQL Server 2008 R2 Express.
When I check ADD/Remove program list of OS, it shows me both SQL Server 2005 and 2008 R2 are installed (that may be I am doing a side by side upgrade but not a in-place one) and when I click on start button of OS and then goes to SQL Server 2008 R2 folder in AllPrograms
list. It has a sub folder configuration tools which contains SQL Server Installation center. When I open the installation center it show various option to install SQL Server 2008 R2 or to upgrade from 2005 etc. I am confused whether SQL Server 2008 R2 is even installed on my machine after running the above 2nd query. Please help me where I am going wrong.