You'll have to do some pretty major MSBuild/TeamBuild hacks to perform the database deployment before the wix solution is built. Are you using VSTS DB project files to maintain your database schema? Are you using it's deployment feature to generate the *.sql? If so, are you deploying the database onto a clean environment? If yes, have you considered generating the *.sql file only (without deployment)? In that case, you might be able to perform the generation as a AfterBuild step in the *.dbproj project itself. If you need to compare against a live database, then I suggest you package up the XML schema and accompanying files in the wix package itself and use vsdbcmd.exe to generate and deploy at install-time or right after installation. There's no built-in help to do any of these things though...
Another solution might be to split up the build process (that's got its own problems... like where to do you get the build output?)... Edwin G. Castro Software Developer - Staff Electronic Banking Services Fiserv Office: 503-746-0643 Fax: 503-617-0291 www.fiserv.com Please consider the environment before printing this e-mail > -----Original Message----- > From: Kerber, Cameron [mailto:cameron.ker...@philips.com] > Sent: Thursday, January 07, 2010 7:57 AM > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] Build WiX Solution After Drop > > So I created a Wix Solution and added it to my Team Build process as > the last solution to build. But I am using source files inside WiX > that aren't created until after my solutions have built and deployed... > So how do I delay the WiX compile. > > Specifically my problem is on the AfterDrop target I am deploying SQL > Databases that create sql scripts on the fly. I need those scripts to > be wrapped into Wix. But the AfterDrop target is called long after my > WiX solution built. > > THanks! > > ________________________________ > The information contained in this message may be confidential and > legally protected under applicable law. The message is intended solely > for the addressee(s). If you are not the intended recipient, you are > hereby notified that any use, forwarding, dissemination, or > reproduction of this message is strictly prohibited and may be > unlawful. If you are not the intended recipient, please contact the > sender by return e-mail and destroy all copies of the original message. > ----------------------------------------------------------------------- > ------- > This SF.Net email is sponsored by the Verizon Developer Community > Take advantage of Verizon's best-in-class app development support > A streamlined, 14 day to market process makes app distribution fast and > easy > Join now and get one step closer to millions of Verizon customers > http://p.sf.net/sfu/verizon-dev2dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
