That sounds like a good idea. Thanks I'll look at updating my installer. On Tue, Jun 28, 2011 at 9:58 PM, Michael Osmond <mosm...@baytech.com.au>wrote:
> Hi > > What I have done, is to have two components for the Database, one is > conditioned to be installed if it is a clean install (not a major upgrade) > and the other is installed on the major upgrade, not on clean install. The > initial table creation script is against the first component, but not the > second component. The second component has scripts that perform upgrades, > and reinstall stored procedures etc. > > Michael > > > -----Original Message----- > From: CoolBreeze [mailto:coolbreeze...@googlemail.com] > Sent: Wednesday, 29 June 2011 11:38 AM > To: General discussion for Windows Installer XML toolset. > Subject: [WiX-users] SQL Scripts Question > > I have a set of SQL Scripts that run and create tables, stored procedures, > and populates a couple of the created tables. We are only doing > MajorUpgrades with our installer. Is there a way that when it comes time to > run a Major Upgrade that I can prevent the SQL Scripts from running again? > I > want to prevent tables that now contain data from being overwritten by the > running of the table creation scripts again. > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
