Geeks With Blogs
Etienne Giust's .NET notes Some .NET tips and tricks for me to remember. That might help you too September 2012 Entries
VSDB to SSDT part 4 : Redistributable database deployment package with SqlPackage.exe
The goal here is to use SSDT SqlPackage to deploy the output of a Visual Studio 2012 Database project… a bit in the same fashion that was detailed here : The difference is we want to do it on an environment where Visual Studio 2012 and SSDT are not installed. This might be the case of your Production server. Package structure So, to get started you need to create a folder named “DeploymentSSDTRedistributa... ......

Posted On Wednesday, September 12, 2012 9:32 PM

VSDB to SSDT part 3 : command-line deployment with SqlPackage.exe, replacement for Vsdbcmd.exe
For our continuous integration needs, we use a powershell script to handle deployment. A simpler approach would be to have a deployment task embedded within the build process. See the solution provided here by Jakob Ehn (a most interesting read which also dives into the '”deploying from Visual Studio” specifics) : For our needs, though, clearly separating our build phase from our deployment phase is important. ......

Posted On Wednesday, September 12, 2012 8:05 PM

VSDB to SSDT Part 2 : SQL Server 2008 Server Project … with SSDT
With Visual Studio 2012 and the use of SSDT technology, there is only one type of database project : SQL Server Database Project. With Visual Studio 2010, we used to have SQL Server 2008 Server Project which we used to define server-level objects, mostly logins and linked servers. A convenient wizard allowed for creation of this type of projects. It does not exists anymore. Here is how to create an equivalent of the SQL Server 2008 Server Project with Visual Studio 2012: Create a new SQL Server Database ......

Posted On Wednesday, September 12, 2012 2:07 AM

VSDB to SSDT Part 1 : Converting projects and trimming excess files
Visual Studio 2012 introduces a change regarding Database Projects : they now use the SSDT technology, which means old VS2010 database projects (VSDB projects) need to be converted. Hopefully, VS2012 does that for you and it is quite painless, but in my case some unnecessary artifacts from the old project were left in place. Also, when reopening the solution, database projects appeared unconverted even if I had converted them in the previous session and saved the solution. Converting the project(s) ......

Posted On Wednesday, September 12, 2012 12:40 AM

VSDB to SSDT Series : Introduction
At the office, we extensively use VS2010 SQL Server 2008 Database Projects and SQL Server 2008 Server Projects in our Visual Studio 2010 solutions. With Visual Studio 2012, those types of projects are replaced by the SQL Server Database Project using the SSDT (SQL Server Data Tools) technology. I started investigating the shift from Visual Studio 2010 to Visual Studio 2012 and specifically what needs to be done concerning those database projects in terms of painless migration, continuous integration ......

Posted On Tuesday, September 11, 2012 10:44 PM

Copyright © Etienne Giust | Powered by: