This is the component we are using in the version 1.0 msi which drops the 
database on uninstallation. And we want to prevent this when we upgrade from 
this to the newer version.


<Component Id="SetupSqlDataBase" Guid="SomeGuid">
<SqlDatabase Id="CreateDatabase" Server="(local)\[SQL_DB_INSTANCE]" 
Database="[SQL_DB_NAME]" CreateOnInstall="yes" CreateOnReinstall="yes">
<SqlScript Id="sqlScript" BinaryKey="sqlScript" ExecuteOnInstall="yes" 
ExecuteOnUninstall="no" ContinueOnError="yes" Sequence="1" 
ExecuteOnReInstall="yes"></SqlScript>
</SqlDatabase>
<SqlDatabase Id="DropDatabase" Server="(local)\[SQL_DB_INSTANCE]" 
Database="[SQL_DB_NAME]" CreateOnInstall="no" DropOnUninstall="yes" 
CreateOnReinstall="no" ContinueOnError="yes" />
</Component>

Thanks 
Sandeep
----- Original Message ----
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Friday, April 13, 2007 10:02:30 PM
Subject: [WiX-users] Partial uninstall of previous version


 
HI All,
 
I ‘m a new user of wix and trying to figure out a good design to solve my 
problem.
 
I’ve one version (say 1.0 ) of my product installed on my system and I want to 
upgrade it to 2.0. After the installation of 2.0, I want to partially uninstall 
the 1.0. 
By partial uninstall I mean remove/unregister files but keep the database. The 
older MSI on uninstall drops the database which is a problem for us.
 
Does their exist a good solution for this?
 
One solution I could think of is to take the DB backup and then Install 2.0, 
call RemoveExistingProducts and populate DB. But I guess this is inefficient.
 
 
Thanks
Sandeep





Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos. 
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/wix-users

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to