question

aRookieBIdev avatar image
aRookieBIdev asked

Visual Studio - DB solution Organizing

All, I am trying to set up a database solution of an existing database into TFS. One of the challenges i have is setting up synonyms. Since Synonyms vary for environment i wanted to set up it dynamically. I tried creating a synonym like the below , but it dint let me have if conditions. Can I create them as pre deployment scripts ? or how to best do it ? Also I need suggestions on release management . How do i create incremental release from the solution ? Thanks in advance .. If ( @@servername = 'dev' ) BEGIN CREATE SYNONYM x END ELSE If ( @@servername = 'qa' ) BEGIN CREATE SYNONYM y END ELSE If ( @@servername = 'prod' ) BEGIN CREATE SYNONYM z END
database-designvisual-studio-2012tfsversion-control
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.