I am pulling my hair out with this problem. Hopefully someone can point out what I am doing wrong. My goal is to have the installer run a script to backup all the databases on the server, install some programs, then run scripts to update the database (structure and layout). There is data in these databases that cannot be lost so simply dropping the databse is not an option.
I can get the installer to correctly install the programs and alter their config files, and I think i can update the database afterwards, but I am surely stuck on the backup. here is my sample code: <--<?xml version="1.0" encoding="utf-8" ?> <Wix xmlns="http://schemas.microsoft.com/wix/2003/01/wi";> <Product UpgradeCode="7aa0bcca-14f8-46c7-8e9d-6a9e523252c1" Name="MyTestSQL" Id="9b5cb943-e741-4fed-b284-6d2d69f578e1" Version="1.1.0" Manufacturer="xxx" Language="1033"> <Package Id="c74f467e-5686-4202-8c54-7ebf83d59c21" Manufacturer="xxx" InstallerVersion="200" Platforms="Intel" Languages="1033" Compressed="yes" SummaryCodepage="1252" /> <SqlDatabase Id="MySqlDatabase" Database="master" Server="(Local)" /> <Directory Id="TARGETDIR" Name="SourceDir"> <Component Id="MySqlComponent" Guid="C50999A0-02FD-42d5-9F65-7375318DD328" DiskId="1"> <SqlScript Id="CreateDatabaseScript" BinaryKey="DatabaseScriptBin" ExecuteOnInstall="yes" SqlDb="MySqlDatabase" /> </Component> </Directory> <Feature Id="DefaultFeature" Level="1"> <ComponentRef Id="MySqlComponent" /> </Feature> <Media Id="1" EmbedCab="yes" Cabinet="setup1.cab" /> <Binary Id="DatabaseScriptBin" src="c:\sqlbak2.sql" /> <CustomAction Id='ConfigureSql' BinaryKey='ScaSchedule' DllEntry='ConfigureSql' Execute='immediate' Return='check'/> <Binary Id='ScaSchedule' src='scasched.dll'/> </Product> </Wix> --> the script I am trying to run contains: BACKUP DATABASE AccountSubmission TO DISK = 'c:\DBBACKUPS\AccountSubmission.dat.bak' GO repeated for each database. When I run the installer, it never seems to execute the script. Please help!!! -- View this message in context: http://www.nabble.com/SQL-Backup-Script-in-WiX-tf3677232.html#a10275934 Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
