We have a number of Cloud Deployment projects for our Cloud Services. e.g.
\-Project.Cloud.UAT
\-ServiceConfiguration.Cloud.cscfg
\-ServiceDefinition.csdef
\-Project.Cloud.Production
\-ServiceConfiguration.Cloud.cscfg
\-ServiceDefinition.csdef
And so on. Each cscfg file has the database connection string for that specific environment.
During the deployment of a cloud project, we run a powershell script which kicks off the azure cmdlets to deploy & start that cloud service.
I'd like to add a step now, to also run FluentMigrator against that environments database. I've previously used FM, and pointed it at a transformed Web.Config to get a SQL Connection string, but can't seem to get it working.
Could someone point me in the right direction with a powershell script to Open the CSCFG file, manually parse out the ConnectionString into a ps $var, and then pass that directly to fluent migrator.