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

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