Same way. So MSI logfile: MSI (s) (E8:08) [15:20:11:575]: Executing op: ActionStart(Name=LaunchVsdbcmd,,) MSI (s) (E8:08) [15:20:11:576]: Executing op: CustomActionSchedule(Action=LaunchVsdbcmd,ActionType=1025,Source=BinaryData,Target=CAQuietExec,CustomActionData="vsdbcmd.exe" /a:Deploy /cs:"Server=SERVER;Integrated Security=true;" /dsp:Sql /dd+ /manifest:"c:\Program Files (x86)\Deployment\DATABASE.deploymanifest" /p:TargetDatabase="DATABASE" ") MSI (s) (E8:B4) [15:20:11:577]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI1AE1.tmp, Entrypoint: CAQuietExec MSI (s) (E8:90) [15:20:11:577]: Generating random cookie. MSI (s) (E8:90) [15:20:11:578]: Created Custom Action Server with PID 8164 (0x1FE4). MSI (s) (E8:78) [15:20:11:596]: Running as a service. MSI (s) (E8:78) [15:20:11:597]: Hello, I'm your 32bit Impersonated custom action server. CAQuietExec: Entering CAQuietExec in C:\Windows\Installer\MSI1AE1.tmp, version 3.5.2519.0 CAQuietExec: "vsdbcmd.exe" /a:Deploy /cs:"Server=D-PTAYLOR-DV;Integrated Security=true;" /dsp:Sql /dd+ /manifest:"c:\Program Files (x86)\Deployment\DATABASE.deploymanifest" /p:TargetDatabase="DATABASE" " CAQuietExec: TSD00566 Deployment script generated to: CAQuietExec: c:\Program Files (x86)\Deployment\DATABASE.sql CAQuietExec: CAQuietExec: SQL01268 c:\Program Files (x86)\Deployment\DATABASE.sql (66,0) Creating ....
Running the VSDBCMD command via a command prompt: "vsdbcmd.exe" /a:Deploy /cs:"Server=SERVER;Integrated Security=true;" /dsp:Sql /dd+ /manifest:"c:\Program Files (x86)\Deployment\DATABASE.deploymanifest" /p:TargetDatabase="DATABASE" " TSD00566 Deployment script generated to: c:\Program Files (x86)\Deployment\DATABASE.sql SQL01268 c:\Program Files (x86)\Deployment\DATABASE.sql (66,0) Creating [dbo].[vw_ViewName]... -----Original Message----- From: John Cooper [mailto:jocoo...@jackhenry.com] Sent: 21 February 2012 14:13 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Incomplete log file entries for when using custom actions We use VsdbCmd for all our database deployments currently. How are you spawning vsdbcmd.exe? The typical output I get is: MSI (s) (B0:B4) [14:24:56:898]: Executing op: ActionStart(Name=JXExecuteVsdbCmd,,) Action 14:24:56: JXExecuteVsdbCmd. MSI (s) (B0:B4) [14:24:56:899]: Executing op: CustomActionSchedule(Action=JXExecuteVsdbCmd,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (B0:4C) [14:24:56:901]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIB7B5.tmp, Entrypoint: JXExecuteVsdbCmd SFXCA: Extracting custom action to temporary directory: C:\Windows\Installer\MSIB7B5.tmp-\ SFXCA: Binding to CLR version v4.0.30319 Calling custom action JackHenry.Enterprise.Deployment.<some_product>CA2!JackHenry.Enterprise.Deployment.VsdbCmdCustomActions.JXExecuteVsdbCmd JXExecuteVsdbCmd: CustomActionData: VsdbCmdPath=C:\Users\JoCooper\AppData\Local\Temp\VsdbCmd\vsdbcmd.exe;DBSchemaPath=C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\Database.dbschema;DeployManifestPath=C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\Database.deploymanifest;SqlConnectionString=Data Source=MMOJXVLMCON11\JHAENTERPRISE;;Integrated Security=True;ActionText=Deploying Jack Henry <some_product> 2011.1 Broadcast Event Database;SyncDomainName=;SyncAccountName=;DomainName=<some_product>CORP;AccountName=JoCooper;HttpPort=80;HttpsPort=443 Action 14:24:57: JXExecuteVsdbCmd. Deploying Jack Henry <some_product> 2011.1 <some_feature> Database TSD00566 Deployment script generated to: C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (17 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) : (1 row(s) affected) SQL01268 C:\Users\JoCooper\AppData\Local\Temp\gnwsvpkn.jfm\<some_feature>DataBase.sql (76,0) Skipping script - SyncManager Not Installed -- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.(r) Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -----Original Message----- From: Paul Taylor [mailto:paul.tay...@collercapital.com] Sent: Monday, February 20, 2012 8:11 AM To: WiX-users@lists.sourceforge.net Subject: [WiX-users] Incomplete log file entries for when using custom actions Is anyone using WiX and VSDBCMD for database deployments and getting log entries to write correctly? Running VSDBCMD via console gives info like: Creating [dbo].[NewTableName]... but this is what is written to the logfile: Creating .... Not sure if the ['s causing the problem. ________________________________ This message and its attachments are intended for the above named only. If you receive them in error, please immediately delete them and all copies of them from your system, destroy any hard copies of them and notify the sender. Coller Capital Limited and each of its associates disclaim any liability for reliance upon any statement, opinion or other writing included within this message or its attachments. Coller Capital Limited registered in England No. 3020017. Registered Office: 33 Cavendish Square London W1G 0TT. ------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users This message and its attachments are intended for the above named only. If you receive them in error, please immediately delete them and all copies of them from your system, destroy any hard copies of them and notify the sender. Coller Capital Limited and each of its associates disclaim any liability for reliance upon any statement, opinion or other writing included within this message or its attachments. Coller Capital Limited registered in England No. 3020017. Registered Office: 33 Cavendish Square London W1G 0TT. ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
