Well, I'll see if I can throw something together. I can't expose the code, but I can describe the component custom actions and the table in enough detail to make it easy enough to re-implement.
The one big gotcha is early releases of the SSDT had versions of SqlPackage.exe that lacked a provision to extend the timeout. This doesn't matter much on a remote deploy if you're only deploying one database, but if you're deploying several, you'll need to extend the timeout by setting a registry entry. We generally set it a 5 minutes (300 seconds) which may be overkill, but works for us. I recommend only use the October 2013 (or later) SSDT package. My technique deploys up to seven databases in this manner. I'm using it in production on eight products currently (and converting an additional product over to it that currently uses SqlScript/SqlString). I'll try to have something up on my blog by Monday. -- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -----Original Message----- From: Levi Wilson [mailto:l...@leviwilson.com] Sent: Friday, January 24, 2014 8:21 AM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] C# Custom Actions / SQL Thanks for the responses guys, that helps a lot. John: do you have any blog posts or anything that speaks to how you're deploying databases and such with WiX with SqlPackage.exe? My other post talks about some of the pain I'm having with a very large SQL script (144k lines) and wondering if SqlPackage.exe would alleviate some of that. Thanks, Levi On Fri, Jan 24, 2014 at 12:53 AM, Blair Murri <os...@live.com> wrote: > If they are not in DTF then the WiX toolset doesn't provide them. It's > assumed that most of what drove you to managed code would already be > in the Framework so there isn't the same level of need to invent the wheel. > > > Having said that, I like John's reply. Cool system. I'll have to > remember that next time I'm faced with installers populating databases. > > > > > > > Blair > > > > > > From: Levi Wilson > Sent: Thursday, January 23, 2014 6:37 AM > To: General discussion for Windows Installer XML toolset. > > > > > > Being out of the WiX installer world for a handful of years, I was > used to writing all of my custom actions in C++. Getting back into > this I noticed that it is now acceptable to write them in C# and the DTF. > > That being said, I have a custom action that is currently written in > C++ that checks for the existence of a database as well as to verify > if a particular table exists. For that, I am using the sqlutil.lib to > make that easier. In C# custom actions, is there an equivalent or do > most people just use SqlConnection / SqlCommand out of the .NET framework? > > Apologies if this is an obvious question, I just didn't want to > re-invent the wheel if WiX had a helper library to assist with this. I > didn't see any SQL related classes in DTF. > > Thanks in advance, > > Levi > > ---------------------------------------------------------------------- > -------- CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical > Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg. > clktrk _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ---------------------------------------------------------------------- > -------- CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical > Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg. > clktrk _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ 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. ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
