SQL Server Data Tools for Visual Studio

The Discussion

• 

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

• 

  Does it work only with .net core solutions?

• 

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

• 

  "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

• 

  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.

• 

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

• 

  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?

• 

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

• 

  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.

• 

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

• 

  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.

• 

   @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

• 

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

• 

  Hi Team, Can I make data changes in my table to be also under source control. For example, I have some master data which needs to be present in all my environments like dev, test and prod, how do I manage those insert update statements in CI/CD pipelines.