Deploying Database migration script to an external database
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