You can use the <sql:SqlScript> tags to execute sql scripts from with in your Wix project. SQLCMD is used to deploy sql database projects, you can have wix execute the command, though this is a fairly complex process and may not achieve your objectives as in some cases it will drop tables. Kind regards Peter
------------------------------------------------------- Peter Solomon 082 535 1844 pe...@nextsteps.co.za On Wed, Dec 8, 2010 at 7:10 PM, Chad Petersen <chad.peter...@harlandfs.com>wrote: > Use the <sql:SqlScript/> element is the WiX way to do it. Working very well > for me. > > -----Original Message----- > From: Anu Dev [mailto:queryl...@yahoo.com] > Sent: Wednesday, December 08, 2010 9:01 AM > To: WIX > Subject: [WiX-users] Run DB Scripts > > Hi > > How can I run DBScripts during the installation process. I have seen an > article > which looks for SQLCMD.exe and calls the respective .SQL files . Is this > the > right way? Can anyone please point me to some pointers on the best practice > to > run DB Scripts. > > Regards > Anweshi > > > > > ------------------------------------------------------------------------------ > This SF Dev2Dev email is sponsored by: > > WikiLeaks The End of the Free Internet > http://p.sf.net/sfu/therealnews-com > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > ------------------------------------------------------------------------------ > This SF Dev2Dev email is sponsored by: > > WikiLeaks The End of the Free Internet > http://p.sf.net/sfu/therealnews-com > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
