SQL Server Data Tools for Visual Studio

Play SQL Server Data Tools for Visual Studio
Sign in to queue


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.




The Discussion

  • User profile image

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

  • User profile image

    Does it work only with .net core solutions?

  • User profile image

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

  • User profile image

    "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

    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

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

  • User profile image

    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

    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

    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

    @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

    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

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



  • User profile image

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

Add Your 2 Cents