[wix-users] IIS / SQL Configuration Wizard Frameworks

[Christopher Painter]

Thanks.  I think it will.   Today they are very much a database first shop.  I'm going to have to see what would be involved to create a model from their existing schema and then use that to transition them to a code first model with a utility that can do automatic migrations.  I wanted to see if anyone else had a better idea before spending time on that.

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Blair Murri
Sent: Sunday, November 20, 2016 3:59 AM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] IIS / SQL Configuration Wizard Frameworks

What I used most recently were the migration classes created by the EF6 code-first wizards (boils down to calling Up() (or Down()) in the correct order, and IIRC there's a migration class in that library that even does that for me.



Don't know if that helps you, though.



Sent from my Windows 10 phone



From: Christopher Painter<mailto:chrpai at iswix.com>
Sent: Saturday, November 19, 2016 8:41 AM
To: WiX Toolset Users Mailing List<mailto:wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] IIS / SQL Configuration Wizard Frameworks



Sure, the IIS part is pretty easy.  I've managed to get the customer requirements narrow (standardized) enough to just use the IIS Extension.

It's the SQL that's a bear.  I've implemented a stock/override pattern for the connection string so that's handled.  The final piece is database change management.  I really want to keep all of that out of the installer and not an installer concern.  I'm looking for some frameworks they can build a custom application on top of to handle  initial database provisioning, security,  backup scheduling and  schema migrations to.  I'd like to just put a shortcut to this utility on the desktop (like TFS Admin Console)  and keep the installer as simple as possible.

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Phill Hogland
Sent: Tuesday, November 15, 2016 10:20 AM
To: wix-users at lists.wixtoolset.org
Subject: Re: [wix-users] IIS / SQL Configuration Wizard Frameworks

I use Microsoft.Web.Administration.  I'm not sure if that is what you are looking for.

________________________________
From: wix-users <wix-users-bounces at lists.wixtoolset.org> on behalf of Christopher Painter <chrpai at iswix.com>
Sent: Tuesday, November 15, 2016 9:34:48 AM
To: wix-users at lists.wixtoolset.org
Subject: [wix-users] IIS / SQL Configuration Wizard Frameworks

I'm working on an installer for an IIS/ASP.NET MSSQL application.  Due to the wide number of ways IIS and the datatier could be configured, I was hoping to keep configuration out of the installer.  I like the way Team Foundation Server did it's post installation configuration wizard.  Does anyone know of any open source frameworks or projects to build upon?



____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/