Skip to content
← SQL Change Automation

How can we improve SQL Change Automation?

SQL Change Automation

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

2 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Benjamin Vg shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Kendra responded  · 

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.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Matthew Chandler commented  ·   ·  Report

    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.