Be able to generate script for azure and non azure
I could be great to be able to generate both the script for azure and non azure at the same time.
A scenario where I need it: I have 3 environments: one non azure and 2 azure and I need to deploy on it by using the octopus.
This is now possible using SQL Change Automation projects, which support development and deployment to Azure SQL Database.
Migration scripts allow you to use conditional logic and to detect the type of target you are deploying to, which should support this scenario.
-
Matthew Chandler commented
Hi Benjamin, thanks for the suggestion. I wonder if you've tried this with SQL Release? What issues did you run into?
I work on the SQL Release development team. If you'd like any help trying to set this up do get in touch, at sqlreleasesupport 'at' red-gate.com.