SQL Server Data Tools for Visual Studio

Sign in to queue

Description

In this episode, Dmitry is joined by Kevin Cunnane to give an overview of SQL Server Data Tools (SSDT) for Visual Studio, a fully integrated SQL Server development environment. In this video we'll demonstrate capabilities such as importing T-SQL into your solution, IntelliSense, table designers, data and schema compare capabilities, and much more.

Resources:

Embed

Download

The Discussion

  • User profile image
    Kent

    Dmitry has to be more calm, imho. Let the guest speak.

  • User profile image
    Question

    Does it work only with .net core solutions?

  • User profile image
    LyalinDotCom

    @Kent: thanks for your feedback Kent, I was excited on this topic :)

  • User profile image
    LyalinDotCom

    "Does it work only with .net core solutions?" - no, SSDT works with any Visual Studio project, so you can be building .NET, .NET Core, Python, WPF, Node.js, really doesn't matter

  • User profile image
    Anton

    Can I somehow disable column rearrangement during schema compare? (ignore column order)
    If I'm not mistaken the default behavior in such case is to create a new table with the correct column order, copy all the data from the old table and drop the old table.

  • User profile image
    Hooligan

    Dimitri, i know your intentions are noble. But please next time, let the speaker speak and interrupt less.

  • User profile image
    VikashMehta

    Great informative video! I will start using the SSDT right way. Only question I have is if someone do the DB changes using SSMS and if I want to import only those DB changes using SSDT, is there any feature in SSDT for this requirement?

  • User profile image
    St3phen

    Great topic to cover - lots of institutionalisation out there (6)

    Agree it would've been more natural to let each presenter talk for longer (rather than the dialogue-style approach.)

  • User profile image
    chandan

    Thanks for the video. I have been using SSDT for more than a year. But publishing even to my local machine db is quite slow.

  • User profile image
    Donovan

    @VikashMehta: You just do a schema compare in VS using the DB as the source and your project as the target. Once it is done you write the changes. This will checkout only the files that are now different. I do it all the time. 

  • User profile image
    Dwain

    Is there any way to save a DataCompare file and not loose the table specific selection?

    I haven't tried it recently, but say I want to only compare 5 tables out of 10, if I try saving the data compare file, the next time I reopen the data compare file, nothing is remembered. So I have to manually select the tables again.

  • User profile image
    kevcunnane

     @Dwain, unfortunately saving table selection is not currently supported in SSDT. Please open a Connect item as that will help us track this request.

    @Vikash, as Donovan mentioned you can compare from Database back to Project and this will let you pull in any changes performed by other developers.

    Thanks,

    Kevin

  • User profile image
    SiaMortazavi

    I love this tool, and the presentation! Thank you both! [H]

Add Your 2 Cents