Thursday, April 18, 2013

Data Tools, DACPAC & BACPAC

Database development is no more just scripts, there are lot of improvement in Database Project development, maintenance and deployment.  in this blog post let me summarize the recent developments.

  • Database Project (Install DataTools from here)
    • Database Project creation
    • Database Reference
    • Compilation and integration errors
    • Warnings and Errors
  • Database Deployment (Part of SQL 2012)
    • DACPAC – Only Schema
    • BACPAC – Schema and Data (JSON format)

DB Tasks

  • Export Import (Available from SQL Server 2005)
    • Script Generation (from SQL 2008 R2, include data in script), Even you can target to SQL Azure.

    imageimage

No comments:

Post a Comment

Teams PowerShell

 The PowerShell helps to get quick meta data around Teams. Install-Module -Name MicrosoftTeams Connect-MicrosoftTeams Get-TeamAllChannel...