I have two environments, development and production. Each one of them has 2 databases, one main database and another that is used as an external data source.
Currently I'm trying to create a github deployment pipeline, I use SSDT to do source control and I have the actions for building the .dacpac and sending it to Azure working. How can I configure so that when in production the database looks to external source of prod, instead of the same external source as dev, when I deploy changes to production?