There are disadvantages to using this mixed approach. Chief among them is that you inherit SqlScript/SqlString's limitations on default instances if SQL browsing is disabled. I've tested and SqlPackage does not have this limitation. That being said, we do have a mix (particularly to implement ALTER RECOVERY SIMPLE), but we're always moving to merge them back into the main package.
Whenever possible, I recommend doing both the schema and data deploy with one method. If you're going to use SqlPackage to deploy the schema, it's not that much harder to have it deploy the default data too. In fact, the schema code runs for us only if: 1) the database doesn't exist; or 2) the schema has changed and can be safely updated. The default data runs only if the data is missing or the scripts decide it is corrupt. We also hae a bunch of scripts run during the package deploy to set roles, logins, and grant permissions. In fact, a lot of these scripts are common to are databases and are shared among. -- 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:40 AM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] C# Custom Actions / SQL 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 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
