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

Managing SQL Role

Recently, we had a scenario, where we need a simple SQL Role which gets read access to bunch of views.  While it was easy to create the vie...