Publish Profile Files in SQL Server Data Tools (SSDT)

re: Publish Profile Files in SQL Server Data Tools (SSDT)

Peter Schott — Tue, 08 May 2012 22:10:22 GMT

That's pretty cool. I knew there had to be something like that around, but this will be great once we get our projects cleaned up and are ready to push to different environments. It will definitely save some typing on command-line deployments.

re: Publish Profile Files in SQL Server Data Tools (SSDT)

jamiet — Tue, 08 May 2012 22:18:43 GMT

Hi Peter,

I knew you'd be the first person to comment here :) Thanks as always!

Yeah, Publish Profile files are very cool indeed. One more reason to upgrade.

Smart defaults [SSDT]

SSIS Junkie — Thu, 31 May 2012 10:55:14 GMT

I’ve just discovered a new, somewhat hidden, feature in SSDT that I didn’t know about and figured it

CASTs become CONVERTs in computed columns with implications for SSDT

SSIS Junkie — Fri, 20 Jul 2012 07:49:23 GMT

I discovered a peculiar little nuance in SQL Server yesterday that I think is worth sharing. Execute

re: Publish Profile Files in SQL Server Data Tools (SSDT)

Aaron Lowe — Mon, 24 Sep 2012 15:12:20 GMT

In VSDBPro I did something similar and was able to tie it into VS Configuration Manager. So selecting the Dev Configuraiton automatically changed my deploy properties. I have, so far, been unable to find that functionality in SSDT publish. Have you seen a way to use VS Configuraitons to select which publish profile you want?

Thanks,

--Aaron

re: Publish Profile Files in SQL Server Data Tools (SSDT)

jamiet — Mon, 24 Sep 2012 15:25:16 GMT

Hi Aaron,

No, I haven't VS configurations too much since Publish Profile files came along. I'm not sure if there is a way to do what you're after (that doesn't mean such a thing does not exist - only that I don't know about it).

Regards

Jamie

Undoing a change will now undo a check-out in Visual Studio 2012

SSIS Junkie — Sat, 26 Jan 2013 22:41:14 GMT

In my blog post SQL Server devs–what source control system do you use, if any? (answer and maybe win

Continuous deployment of SSDT database projects to Windows Azure using Team Foundation Service

SSIS Junkie — Sun, 27 Jan 2013 20:07:38 GMT

Continuous deployment is described by Wikipedia as: Most CI systems allow the running of scripts after

re: Publish Profile Files in SQL Server Data Tools (SSDT)

Jamie White — Wed, 30 Jan 2013 17:47:26 GMT

Great tip, thanks.