1 / 14

Database Projects Within Visual Studio

Database Projects Within Visual Studio. Ronnie Hicks Consultant http ://about.me/ronniehicks. SQL Server Data Tools. Agenda. Database ALM Intro to Database Projects SQL Server Data Tools (SSDT) DAC Framework ( DACFx ) Data-Tier Application Package (DACPAC).

ally
Download Presentation

Database Projects Within Visual Studio

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. Database Projects Within Visual Studio Ronnie Hicks Consultant http://about.me/ronniehicks SQL Server Data Tools

  2. Agenda Database ALM Intro to Database Projects SQL Server Data Tools (SSDT) DAC Framework (DACFx) Data-Tier Application Package (DACPAC) Database management nirvana is within your grasp with these features!

  3. Database ALM is too hard! Refactoring pain Development cycle Database promotion across environments Application/ Database Synchronization

  4. Database Projects (and SSDT) to the rescue! Buffered Declarative editing Model-based design and validation Local testing and promotion Source Control SQL Unit Tests Pre/Post deploy scripts Snapshots Drift detection and comparisons

  5. What is a Database Project? • Offline development of SQL Server Databases • Project-based development • Developer isolation • Rich T-SQL support • Automatic script generation • Pre-Deploy • Post-Deploy • Refactor Log • Verification against the “Model” • Coding standards enforcement

  6. Intro to Database Project Demo

  7. SQL Server Data Tools (SSDT) • SQL Server Object Explorer • SQL Static Code Analysis • Table Designer • Database Publishing • SQL Language Services • Database Unit Testing • SQL/CLR • Isolated Local Database Runtime • Schema Comparison • Data Comparison • Buffered Declarative Editing • SQL Debugging

  8. DAC Framework (DACFx) • Introduced in SQL Server 2008 R2 • Suite of tools, APIs and services • Handles all DACPAC and BACPAC processing • Microsoft.SqlServer.Dac (DAC API)

  9. Data Tier Application Package (DACPAC) • Self-contained unit of SQL Server database deployment • Supported by SQL Server 2005 & above, including SQL Azure • Continuous Deployment • DAC properties within SQL • DAC Versioning

  10. Demos • Create a project from an existing database • Make some changes to this new project • Verify that the changes work • Use SQL Debugger to test these changes in LocalDB • Write some Unit tests • Deploy this database to SQL Azure and update the existing database

  11. That’s why Database Projects rock! Source Control for SQL Server Database versions coincide with application, not just a resource Side-by-side SQL/CLR DACFx and DACPACs SQL Server Data Tools (SSDT) Data-Tier Application (DAC) Multi-team collaboration

  12. Questions?

  13. Thanks!

More Related