0

We have schema utils which we would like to deploy with database objects (procedures, functions, views) to multiple databases on different servers via Azure Devops Pipeline. Is there any option to treat this schema with objects as ddl file which will be attached to multiple database solutions ? Or we have to add manually all scripts to all database solutions ?

Improve this question
3
  • I added tags that I thought were missing, please edit if needed
    – mustaccio
    May 13, 2022 at 14:22
  • So basically your question is "how to efficiently deploy a schema of objects to different databases?"? Would you be open to the idea of deploying them to a single database that all other databases can reference and still use?
    – J.D.
    May 13, 2022 at 18:14
  • Yes, but this schema have to be deployed on every database (not in separate new database)
    – adam.g
    May 15, 2022 at 8:27

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.