slide1 n.
Skip this Video
Download Presentation
Database Projects Within Visual Studio

Loading in 2 Seconds...

play fullscreen
1 / 14

Database Projects Within Visual Studio - PowerPoint PPT Presentation

  • Uploaded on

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Database Projects Within Visual Studio' - ally

Download Now 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Database Projects Within Visual Studio

Ronnie Hicks


SQL Server Data Tools


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!

database alm is too hard
Database ALM is too hard!

Refactoring pain

Development cycle

Database promotion across environments

Application/ Database Synchronization

database projects and ssdt to the rescue
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


Drift detection and comparisons

what is a database project
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
sql server data tools ssdt
SQL Server Data Tools (SSDT)
  • SQL Server Object Explorer
  • SQL Static Code Analysis
  • Table Designer
  • Database Publishing
  • SQL Language Services
  • Database Unit Testing
  • Isolated Local Database Runtime
  • Schema Comparison
  • Data Comparison
  • Buffered Declarative Editing
  • SQL Debugging
dac framework dacfx
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)
data tier application package dacpac
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
  • 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
that s why database projects rock
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


SQL Server Data Tools (SSDT)

Data-Tier Application (DAC)

Multi-team collaboration