1 / 24

Exploring SQL Server Data Tier Applications

DBI309. Exploring SQL Server Data Tier Applications . Gert Drapers (@ DataDude ) Principal Group Program Manager Microsoft Corporation Adam Mahood Program Manager Microsoft Corporation. Agenda. Introduction to Data Tier Applications DACFx : Data Tier Application Framework

teranika
Download Presentation

Exploring SQL Server Data Tier Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBI309 Exploring SQL Server Data Tier Applications Gert Drapers (@DataDude) Principal Group Program Manager Microsoft Corporation Adam Mahood Program Manager Microsoft Corporation

  2. Agenda • Introduction to Data Tier Applications • DACFx: Data Tier Application Framework • DACFx Overview • Demo: SqlPackage.exe • Demo: DACFxManaged API (Microsoft.SqlServer.Dac.dll) • Clients of DACFx • Scenarios supported by DACFx • Demo: SQL Server Data Tools • Demo: SQL Server Management Studio • Demo: SQL Azure Management Portal

  3. Database Lifecycle Management is Hard! • Challenges include… • Developing for different target platforms • Versioning your database alongside your application • Promoting databases across environments • Migrating databases to the cloud • There is a solution…

  4. Introducing Data Tier Applications! • Self contained database entity used by an application • Single unit of deployment and lifecycle management • DAC packages (.dacpac/.bacpac) • Authored along side your application code • Extracted from existing databases • Deployable to SQL Server and Windows Azure SQL Databases • Consistent story for database development, migration, and versioning across the SQL Server platform

  5. SQL Azure Management Portal Import Export Register Unregister Publish Compare Sync DAC SQL Server Management Studio SQL Server Data Tools

  6. DAC Packages .dacpac Packaged Schema representing the declarative model of the database • Not SQL, but a declarative Schema Model representation of the database • Compiled from source code or Extracted from existing databases • Deploy as new database or Upgrade an existing database • Supports all SQL Server database objects and types .bacpac Packaged Schema and Data representing the state of the database • Composed of Schema Model with state-ful properties and Data streams • Exported from existing databases • Imported as a new database or populates an empty database • Supports most SQL Server database objects and types (Azure Parity)

  7. DAC Framework (DACFx) Core SQL Server component providing modeling, reverse engineering, and deployment capabilities • Managed API • Exposes verbs for DAC package operations • Command-line tool (SqlPackage.exe) • Lightweight executable over the managed API • DACUnpack.exe • Windows file handler for unpacking .dacpacsto disk • DACFxClients • SSDT, SSMS, SAMP, VS Web and DB Publishing

  8. DAC Evolution .dbschema v1.2 Visual Studio 2010 Database Projects .dbschema v1.1 Visual Studio 2008 Database Edition GDR .sqlx v1.0 SQL Server Data Tools CTP3 .dacpac v2.5 SQL Server Data Tools CTP4 .dacpac v3.0 consumed by all SQL Server tools .dacpac v2.0 SQL 2012 RC0 .dacpac v1.05 SQL 2008 R2 RTM .dacpac v1.1 SQL 2008 R2 SP1 .dacpac v1.0 SQL 2008 R2 RC

  9. DACFx Object Support and Compatibility • SQL Server 2012 DACFx(v3.0) supports full SQL Server database domain • SQL Server 2005 • SQL Server 2008/R2 • SQL Server 2012 • Windows Azure SQL Databases • DACFx(v3.0) backwards compatibility • DACFx1.0, 1.1, and 2.0

  10. demo DAC Framework (DACFx) SqlPackage.exe C# API

  11. Developer-focused toolset for authoring, building, and publishing DACPACs Experiences Enabled Connected Imperative and Declarative Development Project Based Development Application Lifecycle & Tools DACPAC Actions Build/Snapshot Compare Import into Project Publish SQL Server Data Tools (SSDT)

  12. SQL Server Management Studio (SSMS) DBA-focused tools for creating, deploying, and managing DAC packages Experiences Enabled • Administration and Monitoring • Connected Imperative Development • Configuration and Task Wizards DACPAC Actions Extract Deploy Upgrade Register/Unregister BACPAC Actions Import Export Deploy Database to SQL Azure

  13. SQL Azure Management Portal (SAMP) Subscriber and Operator oriented online toolset for managing Windows Azure SQL Databases through DACFx actions Experiences Enabled • Database Migration • Connected Imperative and Declarative Development • Application Lifecycle support DACPAC Actions Extract Deploy Upgrade BACPAC Actions Import Export

  14. DAC Lifecycle Developer DBA DBA/Admin

  15. demo DACFx Clients SQL Server Data Tools SQL Server Management Studio SQL Azure Management Portal

  16. Summary: Data Tier Applications • Unit of deployment and lifecycle management for SQL Server • Packages contain model representation of the database • DACFx can compile and deploy packages to a new or existing database • Deployable to SQL Server and Azure SQL Database • DACFxis a SQL Server redistributable component with a managed API • DACFx actions surfaced in SQL Server 2012 client tooling • SSDT, SSMS, SAMP, VS Web and DB Publishing

  17. Resources • SQL Server 2012 Feature Pack Downloads • http://www.microsoft.com/en-us/download/details.aspx?id=29065 • SQL Server Data Tools Online Installation • http://msdn.microsoft.com/data/toolsGet It • SSDT Team Blog • http://blogs.msdn.com/b/ssdt/ • MSDN Forum • http://social.msdn.microsoft.com/Forums/en-US/ssdt/threads

  18. Related Content • DBI311 - SQL Server Data Tools: Database Development from Zero to Sixty DBI31-HOL - Getting Started with SQL Server Data Tools in SQL Server 2012 DBI07-TLC - SQL Server: Cloud on Your Terms - Optimized Productivity

  19. DBI Track Resources @sqlserver @teched_europe #msTechEd SQL Server 2012 Eval Copy Hands-On Labs Get Certified! mva • Microsoft Virtual Academy

  20. Resources Learning TechNet • Connect. Share. Discuss. • Microsoft Certification & Training Resources http://europe.msteched.com www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet http://microsoft.com/msdn

  21. Evaluations Submit your evals online http://europe.msteched.com/sessions

  22. © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related