none
SQLPackage and Deployment plan modifiers

    Question

  • Hi

    does SSDT and more specifically SqlPackage.exe support deployment plan modifiers in the same way that VS2010 & VSDBCMD does ?

    Dave


    Dave Ballantyne ---- http://sqlblogcasts.com/blogs/sqlandthelike/

    mercredi 7 mars 2012 07:09

Réponses

  • Hi Dave,

    SSDT (and SqlPackage) does not yet support Deployment Contributors like could be created and used in the existing VS2010 Database Project system. We are considering plans for incorporating these extensibility points into the product for a future release.

    Thanks for your feedback,

    Adam


    Adam Mahood - Program Manager - SQL Server Data Tools

    mercredi 7 mars 2012 16:41
    Propriétaire

Toutes les réponses

  • Hi Dave,

    SSDT (and SqlPackage) does not yet support Deployment Contributors like could be created and used in the existing VS2010 Database Project system. We are considering plans for incorporating these extensibility points into the product for a future release.

    Thanks for your feedback,

    Adam


    Adam Mahood - Program Manager - SQL Server Data Tools

    mercredi 7 mars 2012 16:41
    Propriétaire
  • Dave,

    Out of interest, what are you using Deployment Contributors for in VS2010 database projects?

    Want to make sure we can support that scenario going forward.


    -GertD @ www.sqlproj.com

    jeudi 8 mars 2012 06:29
    Modérateur
  • Hi Gert,

    So, the issue we have is that we developing an automated
    deployment solution using vs2010 at the moment. 

    Our big headache has been the artefacts that are required by
    replication and ensuring that these are not changed by such a deployment.  Mostly this is fine , we have ‘hidden’ many
    objects using the extend property of Microsoft_system_.. (something :;).  But the issue I am with right now is the
    check constraint used in merge replication ( MSRepl_XXXX something…) , which I was
    hoping to be able to mask with the modifiers.

    Plan b is to have a powershell script to update the source
    (dacpac / dbschema) with the live constraint name and constraint condition , so
    it is seen as a ‘no change’ item.



    Dave Ballantyne ---- http://sqlblogcasts.com/blogs/sqlandthelike/

    jeudi 8 mars 2012 07:23
  • Hi Dave,

    In SSDT we added a deployment option named, to ignore replication related objects, named "Do not ALTER replicated objects", I would first try if that helps you.

    You can use this option both from MSBuild using the publish profile or using SQLPackage.exe

    In general sqlpackage.exe will give you more freedom (less dependencies to install, only DACFramework.msi) and options over MSBuild /t:deploy besides that you can use it from an API and are not tight to the MSBuild environment.

    Let me know if this helps,


    -GertD @ www.sqlproj.com

    samedi 10 mars 2012 19:25
    Modérateur
  • Hi Gert,

    Things have moved on, extensions with a RegEx pattern is working just fine to exclude certain DDL that is produced by the MSBUILD /t:deploy setting.  Being tied to MSBuild is not an issue for us ( at least at the moment :) ).

    Thanks for the info,  for completeness ill try the option and see what coverage , in terms of exclusions,  we get

    Dave


    Dave Ballantyne ---- http://sqlblogcasts.com/blogs/sqlandthelike/

    dimanche 11 mars 2012 11:14
  • I have the same question.  When will SSDT support Build and Deployment Contributors like VS2010 Database Projects does?

    Brian Barnett
    http://www.profisee.com
    “As the original creators of Microsoft MDS, Profisee's Master Data Maestro provides a range of enterprise-grade functionality to ensure MDS project success.”

    mardi 18 septembre 2012 19:07