RE: VS 2005 DB Pro Edition, PostDeploy problem

Sorry but I didn't quite follow. Basically I want to run different sql script
file after the DB project is deployed to server based on the project/solution
configuration. I don't know how to use the method you give me. Please advice.

--

Thanks.

Daniel


"WenYuan Wang [MSFT]" wrote:

Hi Daniel,

Do you mean you want to generate different scripts according to the
solution configuration?
If true, you may consider Macros. Though visual studio macros, you can get
the property of SolutionConfiguration. Below is an example about how to
change project configuration. You may have a look. Hope this helps.

Sub ChangeProjectConfiguration()
Dim solutionBuild As EnvDTE.SolutionBuild
Dim solutionCfgs As EnvDTE.SolutionConfigurations
Dim solutionCfg As EnvDTE.SolutionConfiguration
Dim solutionContext As EnvDTE.SolutionContext
'Find the debug solution configuration:
solutionBuild = DTE.Solution.SolutionBuild
solutionCfgs = solutionBuild.SolutionConfigurations
solutionCfg = solutionCfgs.Item("Debug")
'Retrieve the solution context for the first project:
solutionContext = solutionCfg.SolutionContexts.Item(1)
'Change the debug solution context to build the
' Release project configuration:
solutionContext.ConfigurationName = "Release"
'Reset the build flag for this context:
solutionContext.ShouldBuild = True
End Sub

Have a great day,
Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • RE: VB 2005 and Content Security Question
    ... must the sensitive data be stored in SQL Server database ... if you have some sensitive configuration setting that need to ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.languages.vb)
  • RE: ConfigurationPropertyAttribute.IsRequired Property
    ... When I read the settings in code if it is false, ... As for the "how to test the missing of a configuration section in .net ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: System.Configuration.AppSettingsSection doc error?
    ... I have filed an request to the MSDN team to confirm the issue. ... Configuration configuration = ... support a "Set" method. ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework)
  • RE: Custom Configuration Section Handler and Code Access Security
    ... custom configuration section handler(defined in the main assembly). ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.general)
  • RE: VS 2005 DB Pro Edition, PostDeploy problem
    ... Dim solutionBuild As EnvDTE.SolutionBuild ... 'Find the debug solution configuration: ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vsnet.ide)