Hi,
Currently we're using SqlDatabase to create and setup the database:
<Component Id='SqlComponent.SQLAuthentication' Guid='{xxx}'
KeyPath='yes'>
<Condition><![CDATA[USEINTEGRATEDSECURITY<>1]]></Condition>
<sql:SqlDatabase Id='SqlDatabase.SQLAuthentication'
Database='[DATABASE_NAME]' User='SQLUser' Server='[DATABASE_SERVER]'
CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no' />
<sql:SqlScript Id='SqlScriptSQLAuthentication'
BinaryKey='CreateTablesBin' SqlDb='SqlDatabase.SQLAuthentication'
ExecuteOnInstall='yes' />
<sql:SqlFileSpec Filename=''/>
</Component>
This works great on first install.
It's important that the data is not lost on an uninstall, hence the drop
being set to no.
If the user does an uninstall/install, we get an error on the new install
because the table files still exist in the SQL instance folder:
CREATE DATABASE failed. Some file names listed could not be created.
Check related errors.
Logically this makes sense. Is there any way to make the SqlDatabase object
re-attach to these files? I cannot see anything in the docs. Or are we
going to have to do a file search and have some conditional logic with
SqlScripts and the SqlDatabase directly under a Fragment to handle this?
Thanks, Dave
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
