Thursday, April 18, 2013


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.


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...