SSDT – Fast deploy

Let me state first of that I do really like SSDT, integration of a source control system of your choice and all its extra features make its use a real boon.

However……..

On my past few assignments SSDT has been heavily used, and deployment is done via Build/Deploy powershell scripts.  This is all very well and good and makes for predictable,repeatable deployments  but it does slow you down rather a lot: You make a change to a SQL artefact, then build which takes a minute or two, then deploy which once again takes a minute or two.  This over the course of a day adds up to rather a lot of time,  it also means that mostly development is done in SSMS then cut-n-pasted into SSDT on completion which really negates a lot of the advantages of SSDT and makes it no more useful than a historic system using Source safe as source control.

 

This got me to thinking that there should be a faster way to deploy during development, so have now extended TSQL Smells to do exactly that.  Right Clicking  on a file ( or folder ) will now show you the “Fast Deploy” option

FastDeploy

 

 

This will deploy the selected scripts directly to your selected SQL host without the kerfuffle of a full build-deploy cycle.  User feedback is given in the Output->TSQL Smells window, if nothing appears to be happening this should tell you why.

CMDVars are supported in the Tools->options->TsqlSmells-> Deploy CMD Vars, just enter them as key-value pairs.  These are kept in the registry so will persist over SSDT sessions,  you also set the database to connect to here.

You can download the latest version from here : http://1drv.ms/MEOp6H

Install instructions etc are available here : http://dataidol.com/davebally/ssdt-tsql-smells-add-in/

Let me know how you get on : parser@clearskysql.co.uk

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *