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 ?

  • I added tags that I thought were missing, please edit if needed
    – mustaccio
    May 13 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 at 18:14
  • Yes, but this schema have to be deployed on every database (not in separate new database)
    – adam.g
    May 15 at 8:27


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.