SQL Server Data Tools for Visual Studio

Download this episode

Download Video

Download captions

Download Captions

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

Format

Available formats for this video:

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

    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

    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.