DLM Automation releasing to multiple environments...
ewomack
Posts: 15
Hello,
I am setting up DLM Automation with Visual Team Services 2015 to build and release the same build to multiple environments. For example, I have a Dev environment that uses specific accounts and occassionally a different table name. I also have a PreProduction and environment that uses different accounts and different occassional table name changes.
Are there best practices around releasing to lower environments and releasing only the accounts needed in those environments versus releasing to PreProduction with only the accounts that that environment needs?
For example, when I release to Dev, I want it to release an account called "Dev" and when I release to PreProduction I want it to release an account called "PreProd" and NOT release the "Dev." I hope I'm making sense.
Do people typically use a RedGate tool for these transforms or can this be done with SQL database detection within the scripts themselves? Or is this a job for PowerShell?
Thank you!
I am setting up DLM Automation with Visual Team Services 2015 to build and release the same build to multiple environments. For example, I have a Dev environment that uses specific accounts and occassionally a different table name. I also have a PreProduction and environment that uses different accounts and different occassional table name changes.
Are there best practices around releasing to lower environments and releasing only the accounts needed in those environments versus releasing to PreProduction with only the accounts that that environment needs?
For example, when I release to Dev, I want it to release an account called "Dev" and when I release to PreProduction I want it to release an account called "PreProd" and NOT release the "Dev." I hope I'm making sense.
Do people typically use a RedGate tool for these transforms or can this be done with SQL database detection within the scripts themselves? Or is this a job for PowerShell?
Thank you!
Comments
The DLM Automation does not support releasing to multiple environments. However as you are using Visual Team Services, you can trying adding a post-script to achieve your goal, using powerShell or sqlcmd to if deploying to PreProd use account_y.
I hope the above helps.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Can you elaborate on the "account_y" that you mentioned in your previous post?
Thank you!