SQL Server Data Tools for Visual Studio

Download this episode

Download Video

Download captions

Download Captions


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.




Available formats for this video:

Actual format may change based on video formats available and browser capability.

    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.



    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.