ReadyRoll and Urbancode

smehaffie

Can you incorporate ReadyRoll deployments into Urbancode. That is the deployment tool we use where I work, so any solution we use for SQL deployments would have to be able to be integrated into our Urbancode builds.

dnlnln

Thanks for your question on ReadyRoll projects with Urbancode.

As you've pointed out, ReadyRoll does not have a special plugin for the build/deploy/release products that Urbancode offer at the moment.

However, ReadyRoll's build system is actually based on MSBuild, which does have plugin support within Urbancode Build:
https://developer.ibm.com/urbancode/plu ... ld-ubuild/

You just need to point the plugin step to your solution file and specify the GenerateSqlPackage=True MSBuild property, per the settings described on this page:
https://documentation.red-gate.com/disp ... Deployment

Collect the artifacts produced by this step (<ProjectName>_Package.sql and <ProjectName>_DeployPackage.ps1).

For deployment, you can use the Urbancode PowerShell plugin:
https://developer.ibm.com/urbancode/plu ... ation/1-2/

Set the plugin step's "PowerShell Script" setting as follows:

& { $DatabaseServer='<DatabaseServer>'; &'<OutputPath><ProjectName>_DeployPackage.ps1' }

Fore more information about how to use the PowerShell script, please see the ReadyRoll documentation:
https://documentation.red-gate.com/disp ... Deployment