Offical team blog for SSDT, a tool for on and off-premise database development
PASS Summit 2012 is just around the corner! If you’ll be at PASS next week, make sure to sync up with the SSDT team through one of the following avenues. We look forward to seeing you there.
SSDT members will be staffing the Optimization & Programmability booth in the Exhibit Hall, where we’ll be able to discuss SSDT and answer any questions you may have.
Database Development with SSDT and Visual Studio 2012 (AD-321-M)
Friday, November 9 at 2:45 – 4:00 PM
Speakers: Barclay Hill, Adam Mahood, Gert Drapers
Tired of hand-coding change scripts to develop, deploy, upgrade, and migrate your databases? Come see the next generation of database development tools in Visual Studio 2012. SQL Server Data Tools (SSDT) transforms traditional database development by introducing a declarative, model-based experience that supports both online and offline (project-based) database development. Many of the development features enjoyed by application developers for years are now available to database developers to manage their databases. This session will introduce SSDT and dive into a series of demonstrations on how you can develop, debug, refactor, and maintain SQL Server and SQL Azure databases from within the Visual Studio 2012 integrated environment.
SQL Server 2012 LocalDB: Your New Friend
Wednesday, November 7th at 1:30 – 2:00pm in Room RC-4
Speaker: Gert Drapers
Need a local database for your application? Want it to have the same programming model as SQL Server? Need it to be under full control of your application? SQL Server 2012 LocalDB will give you all this. Gert will discuss how to embed SQL Server LocalDB underneath your application.
Declarative Database Deployment, Tell me what you want, Not how you want to get there!
Wednesday, November 7th at 3:30 – 4:00pm in Room 4C-4
Wouldn’t be great if you can describe how you want your schema to look like, instead of writing down how to implement it? Declarative database deployment, the underpinning of SQL Server Database Tools – Database Projects gives you exactly that. Gert will discuss the fundamental behinds DAC and the database deployment engine.
Building & Deploying SSDT projects without Visual Studio
Thursday, November 8th at 2:30 – 3:00 in Room 4C-4
Speakers: Patrick Sirr and Mike Kaufman
Speakers will give a review of how to use SQL Server Developer Tools (SSDT) projects outside of Visual Studio. Specifically, we’ll cover MSBuild integration, TFS integration & integrating deployment tasks into broader commandline and powershell scripts.
Getting Started with SQL Server Data Tools in SQL Server 2012 (SQL 161)
Daily in room 304 (3rd floor of TCC )