asked
How to reference the reference project configuration settings from PostDeployment SQL script
My VS2010 solution several configurations (Debug, Release, etc). One of the projects is a database project. In the PostDeployment script in this project, I want to perform a different action depending on the which particular configuration is being deployed. For example, I want to do something like this in the PostDeployment script: IF $(ConfigurationName) = 'Release' .... -- Do some T-SQL here ELSE IF $(ConfigurationName) = 'Debug' .... -- Do some other T-SQL here I don't know how to reference the VS solution settings from the T-SQL SQLCMD script. Can someone explain how I do this?
Have a look at this discussion about different post deployment scripts for Release and Debug: **[
http://social.msdn.microsoft.com/Forums/en/vstsdb/thread/cd3bbbac-c32c-4683-bb85-f93733abd711][1]** [1]:
http://social.msdn.microsoft.com/Forums/en/vstsdb/thread/cd3bbbac-c32c-4683-bb85-f93733abd711
