Thanks! I was planning on only using it to do my initial schema setup, and have SqlScript do everything else. My current RedGate schema export is 144k and it takes 6 minutes for the C++ CA to parse it :( Just trying to figure out my options.
On Fri, Jan 24, 2014 at 9:33 AM, John Cooper <jocoo...@jackhenry.com> wrote: > 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 > ------------------------------------------------------------------------------ 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
