We are using the limited version of Deployment Manager and like what it has to offer. But I am having a problem solving one issue.
We have a structure that supports multiple identical databases in several environments (staging, training etc.) . These environments can have 1-x of these databases all starting with the same prefix but varying endings. (Database_01,Database_03 etc.) I have Jenkins batch scripts to update the base structure and it is working fine since the base structures all have the same name. Is there a way to/or a powershell example that would allow me to cycle through the databases and update the structures. I am calling sqlci.exe in the Jenkins job.
Can I do this using Powershell and the deploy.ps1 module? Any examples of how to setup the deploy.ps1 for database deployment?
Here is a structure example:
Tenant databases: Database_01,Database_99
Tenant databases: Database_01,Database_02,Database_03,Database_99
I hope that is clear
Thanks in advance.