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

Sign in to queue

The Discussion

  • User profile image
    Liero

    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
    OzBobWa

    @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
    Rob

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

  • User profile image
    reckface

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

  • User profile image
    Mohit

    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.

    Regards,
    Mohit

Add Your 2 Cents