This is how I run a sql script: http://neilsleightholm.blogspot.com/search/label/SQL, although I don't drop on uninstall but that could be arranged.
Neil -----Original Message----- From: Lourens Wepener [mailto:lourens.wepe...@avanade.com] Sent: 28 August 2009 16:42 To: wix-users@lists.sourceforge.net Subject: [WiX-users] SQL Script Deployment Hi, I am trying to get WIX to deploy a SQL database script. We are building a database project using VSTS 2008 and deploying it locally (on build server). When VSTS deploys, it creates a databaseName.sql file. This file contains the script to drop / create the database / permissions / views etc and also insert data that exists in the post deploy scripts. So, I would like to run this script with WIX, to create the database and then drop the database on uninstall. This type of script also needs to be run in SQL CMD mode. What is the best way to achieve this? I have tried various ways and have had no luck, the best / closest way I got was to have a master sqldatabase under product and then sclscript as a component that would create the database. But that returns a parse error. Please let me know if you need any more info :) Many Thanks in advance. Lourens ------------------------------------------------------------------------ ------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
