In our current setup using MS Database Projects, we use sql command variables to achieve this and a master file containing all these variables. This file is changed dependent on the target environment and allows us to change linked server definitions, synonyms etc.
Will SQL Source Control / Deployment Manager support this ? If it could, it would greatly simplify tackling issues like this.
In our current setup using MS Database Projects, we use sql command variables to achieve this and a master file containing all these variables. This file is changed dependent on the target environment and allows us to change linked server definitions, synonyms etc.
Will SQL Source Control / Deployment Manager support this ? If it could, it would greatly simplify tackling issues like this.