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
Sign in to queue

Description

Watch this session to learn how to use SQL Server Data Tools in Visual Studio 2017 to quickly develop a SQL Server database that runs anywhere and an Azure SQL database. Learn how to automate your application and database CI/CD pipeline by using Visual Studio Team Services.

Product info: docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
Learn more: msdn.microsoft.com/library/hh272686(v=vs.103).aspx
Documentation: msdn.microsoft.com/library/hh272686(v=vs.103).aspx

Create a Free Account (Azure): https://aka.ms/azft-sql

Day:

0

Session Type:

On-demand

Code:

T176

Embed

Download

Download this episode

Download captions

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

  • User profile image
    Jordan​Sanders
    Such a useful video, thanks! On my way of DevOps process implementation, I use DevOps Automation tool https://www.devart.com/dbforge/sql/database-devops/

Add Your 2 Cents