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

TSql Script out data

In SQL Server Management Studio (SSMS) you can generate script out the DB Object, you can also generate script for data (Insert statements...