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