What are the challenges you face when working across database platforms? Take the survey

How to deploy to 300 databases across 2 SQL servers?

Currently we are looking at SQL Change Automation for database deployments. I already watched the video on how to do the deployments but have some questions. 
  1. Is there a way to make the database list dynamic v hardcoding the names?
  2. How is that done when using Azure CI/CD?
  3. Is it possible to also make the server dynamic?
  4. How does this extend to all environments? 
I know our current number of databases is the norm for most people. We are working on a solution to make the database more multi tenant. As many know this is going to be a long process. Any advice or examples would be greatly appreciated. Thanks.


Sign In or Register to comment.