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 [email protected] On Wed, Dec 8, 2010 at 7:10 PM, Chad Petersen <[email protected]>wrote: > Use the <sql:SqlScript/> element is the WiX way to do it. Working very well > for me. > > -----Original Message----- > From: Anu Dev [mailto:[email protected]] > 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 > [email protected] > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
