Deploying Database migration script to an external database

EricLamontagne

Hi,

We are developing and selling a solution using SQL Server database.

We an home made "installer" taking migration scripts and upgrading existing client databases when they do an upgrade.

We would like to replace this home made installer with SQL Change Automation, but so far, all I have found is how to deploy the migration using CI/CD pipelines.

We want to be able to package all the changes from one release to another and have them performed on every client databases as needed. I guess we want to have a binary or a powershell script that would run the migration script that SCA is creating.

We do have a build pipeline, but the final artifact would be the binary/powershell script, not a deployment.

What am I missing? Is this possible?

Please point me to some documentation or video that would explain how it can be done

Thanks,

Eric

Sergio R

Hi Eric,

Yes, this is possible using SQL Change Automation.

1 - At your end, you can use SQL Change Automation for development and to build.
https://documentation.red-gate.com/sca/developing-databases
https://documentation.red-gate.com/sca/deploying-database-changes/continuous-integration

When this process finishes you should have nuget package that you can distribute

2 - You can then embed the nuget package you've created together with a Powershell script that

     a - Installs (or updates) Powershell Get and SCA Powershell*
     https://documentation.red-gate.com/sca/getting-started/installation/installing-powershell-components

     b - Creates and deploys a release on your customer's databases
     https://documentation.red-gate.com/sca/deploying-database-changes/automated-deployments

If you have any licensing queries related to this, please contact our Sales Department at sales@red-gate.com

     

EricLamontagne

Thank you Sergio for your answer. I will keep investigating and read your suggested links!

I'll come back to mark the question as answered or with more questions if any.

Eric