Geek asks and answers

Updating an SQL Instance Through ClickOnce

I have a Winforms application that has been deployed through ClickOnce, which has the SQL Server 2005 Express prerequisite. I would like to change this to SQL Server 2008 R2 Express.

I looked package.xmlfor SQL Server 2008 R2 Express and noticed the lines:

<!-- Defines an upgrade installation (x86) -->
-<Command Arguments="/q /hideconsole /action=Upgrade /instancename=SQLEXPRESS 
                     /IAcceptSqlServerLicenseTerms /skiprules=RebootRequiredCheck" 
          PackageFile="SQLEXPR32_x86_ENU.EXE" 
          EstimatedInstallSeconds="420" EstimatedInstalledBytes="225000000">

This SEEMS means update is possible. However, when I tried to complete this, it was unsuccessful, prompting me to delete the existing instance SQLEXPRESS.

Does anyone know if this is possible? Maybe I'm doing something wrong? Do you just need to go the extra mile and encode the deletion of an existing instance of SQL? Has anyone dealt with something like this?

PS Does this apply to database administrators ( https://dba.stackexchange.com/ )? I was not sure about the ClickOnce context of my question.

+5
source share
1 answer

I should have done the same a while ago. What I did was do as you described and code the deletion for SQLExpress.

But I did this in the boot module of the application, I checked the installed version, started uninstalling it, then checked again (in case of cancellation of the user), and then restarted the application.

Clickonce sees missing prefixes that are missing and disabled for installation.

He wound for a very long time, but worked.

SQL Everywhere ( SQL Compact ), DLL ​​ messing. ( -). f

+1

More articles:


All Articles