Build with an Azure free account. Get USD200 credit for 30 days and 12 months of free services.

Start free today

Database DevOps with SQL Server Data Tools and Team Services

Play Database DevOps with SQL Server Data Tools and Team Services

The Discussion

  • User profile image

    Hi @Eric Kang, thanks for the session.

    SSDT look great, but unfortunately it isn't very useful in real world CI/CD, because it fail to update existing database if there are data. Unless I'm missing something.

    Without ability to write custom migration scripts for specific changes, like changing column datatype, or adding non-nullable column without default value, I have to update the existing database manually anyway.

    Do you have some tips how to deal with such changes?

  • User profile image

    @liero there is a project property to configure that and other options.


    i am enjoying the tests UI for my stoed provedures



  • User profile image

    The page does not play videos correctly on edge browser on mobile. I am using the note 8.

  • User profile image

    Do you have any examples with on premises (non-Azure) database deployments.

  • User profile image

    Hi Eric,

    Thanks for this great demo. I am trying to follow the same process to deploy on Azure SQL server. However, I am running into an issue. The release pipeline requires account with SQL Authentication support but in order to execute statement like 'CREATE USER [r_azure_sd_sql_admin] FROM EXTERNAL PROVIDER' we essentially need Azure active directory password/integrated authenticated user.

    So, is there support for any AAD authentication in the release pipeline as I am not sure if we can have a SQL authentication enabled for Azure AD user. Any help is greatly appreciated.

    Please let me know your thoughts.


  • User profile image
    Such a useful video, thanks! On my way of DevOps process implementation, I use DevOps Automation tool
  • User profile image

    Trying to use SSDT on VS0217 and 2019 and can't get rid of "SQL71501 unresolved reference" and "SQL71561 unresolved reference". All these errors are in views

    I have added a REF to Master and MSDB. What am I missing?

    Thanks in advance

Add Your 2 Cents