Peter Schott (3/27/2015)
Appreciate the pointer on T4 support, Jack. I've know about the concept for a while, but adding that to my toolkit now. It looks pretty cool, if still "an opportunity for developers" out of the box. 🙂And a link for more info for those just hitting this for the first time:
There is actually a specific T-SQL T4 template available for Database Projects. The only post/article I know of on it is by Dave Ballantyne, http://dataidol.com/davebally/2014/03/29/t4-support-in-ssdt/, and I have looked. There is a decent presentation available on it from last year's SQLBITS as well, www.sqlbits.com/Sessions/Event12/T4_Templating_within_SSDT_using_SQL_Server_2014. I also have a presentation I do on it, that I did submit to the PASS Summit this year, so hopefully I'll be speaking on it there.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question