Search
-
synonyms and deployment.
Discussion by spakh · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsI have synonyms defined in my database that differ in their definitions depending on which server the database is installed. For example, on my dev and test servers, one of the synonym is defined as: CREATE SYNONYM [dbo].[SYN_TMAGENT] FOR [TPSSYNC].[ANDRXTST].[AGID06USR].[TMAGENT] On the production server the synonym is… -
Re: synonyms and deployment.
Comment by David Atkinson · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsWhat is needed here is variable substitution, where you define a variable instead of the explicit value for the synonym. Depending on whether you're deploying to dev, test or production, the variable should be substituted accordingly. Unfortunately this feature doesn't exist right now, but I think it would be great if you…
2 results