If you write code to SQL Server then you might be interested in this: I have written a tSQLt tdd training course which has helped over 500 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club.

SSDT DevPack + Visual Studio 2017

I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and have started to think about how to improve it going forward.

The first feature of sorts is the ability to clear the connection used by the quick deployer without having to restart visual studio.

Secondly I am pretty convinced that the main thing people use it for is the quick deploy, the tSQLt test builder and I use the keyword formatters so I have moved everything else to underneath a menu item saying “deprecated” - if anyone really wants one of those features then let me know and I will keep it but I will likely remove them at some point.

I am planning on bringing SQLCover into it at some point and I haven’t really been using the mergeui part, I think the better thing is to use sp_generate_merge to generate a merge statement it is much more reliable. If you have a simple table then MergeUi might still be useful to you.

I will publish it to the market place so updates happen automatically, if you want a copy of it go to:

https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5…

Before I published it I realised that when I wrote the code (a couple of years ago!) that I had taken a couple of shortcuts, one was to always use the 120 version of the parsers instead of whatever the project was set to so I decided to fix that first and then publish - looking over old code is never good ha ha.

It is now published so you should be able to install for vs 2017 and existing installs on 2015 will be upgraded (hope it doesn’t break for anyone, there are lots more users than when I last published it!)


Comments:

Shane Fitzgibbon

May 10, 2017 - 02:51

Cannot get tSQLt commands to work in VS2015

Hi

When I attempt to create a tSQLt test class with the SSDT Dev Pack I receive the following error in the General Output:

Exception creating tSQLt schema, error: Could not load type ‘Microsoft.SqlServer.TransactSql.ScriptDom.TSql140Parser’ from assembly ‘Microsoft.SqlServer.TransactSql.ScriptDom, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’.

Any ideas?

Ed Elliott

May 31, 2017 - 12:10

hey shane - this should have

hey shane - this should have been included as a dependency, i’ll take a look at it but try installing the latest DacFx from:

https://www.microsoft.com/en-us/download/details.aspx?id=53013

this should install the 140 parser bits.

How do

May 31, 2017 - 12:08

This is how I do it

When I want to quit vim I use this guide: https://howdoiquitv.im/how-do-i/quit-vim/ it is great as I can click the copy button and then follow it to get a better explanation.

If I want to find text in files on windows I use this: https://howdoiquitv.im/how-do-i/find-text-in-files/windows/

They are both great resources for beginners.

Subscribe

* indicates required

Please select all the ways you would like to hear from Agile Sql Club:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.