so I am trying to deploy changes from my CoreDb repo , that’s a SQL database project to a release. This release would just be script changes that multiples countries would grab into their repos and make changes from there. I can’t deploy directly to all the countries because some countries are on different versions than others.
The CoreDb repo is a SQL project as well that contains all the common files for all countries. I only handle the CoreDB repo, the country’s local dev teams will handle their repos.
I created my CoreDB repo with a build pipeline and a release pipeline. I’m not sure how to connect the process of the country repos retrieving these releases (by version) for their own repos.
I was thinking either:
-
create stages for every country in my CoreDb release pipeline that will manually be deployed, but then I’m not sure how we would handle merges in the sql files or will files get replaced?
-
Create a deployment task of some sort in my release pipeline that would execute scripts that would call the git commands to pull my CoreDb repo into their country’s repo. The countries would update the script with their country name and what version they need and the script would do the git commands.
I already tried using git to pull the Core DB repo into my test project and merge the changes, which works, but my boss wants the process to be more streamlined, because we have 27 countries.
2