@lsjames:I'd have to dig into your scenario a bit to answer this fully. In general, DAC upgrade will try the most minimally invastive upgrade strategy possible. I'm a bit suprised that it's messing with users, are you using DAC Fx 3.0 (that ships with RTM SQL 2012)?
@Borum.NET: thanks for the comments! Here's some answers to your questions:
Q: Is there a managed API (like the SQL SMO) that allows us to include dacpac files in our own installer and subsequently deploy (clean install / upgrade) to on premise SQL Server or SQL Azure?
Q: The scenario I'm thinking of is having a single SQL Server Data Tools project as part of our solution and using TFS builds output dacpac files for SQL Server or SQL Azure (i.e. targetting the two different environments via configuration and then build the dacpacs). Is that possible?
A: Absolutely. Think of .dacpac and .bacpac as a single-file deployment capability for schema (.dacpac) and schema + data (.bacpac).
Comments
Demo 4 - SQL Server Connections Spring 2012 Shawn Bice Keynote
Want more? Check out all the presentations, demos and labs at http://bit.ly/sql2012cookbook.
Demo 3 - SQL Server Connections Spring 2012 Shawn Bice Keynote
You can see part 4 of this demo in this post.
Want more? Check out all the presentations, demos and labs at http://bit.ly/sql2012cookbook.
Demo 2 - SQL Server Connections Spring 2012 Shawn Bice Keynote
You can watch part III in this post.
Want more SQL Server 2012 content? Check out all the presentations, demos and labs at http://bit.ly/sql2012cookbook.
Demo 1 - SQL Server Connections Spring 2012 Shawn Bice Keynote
Check out Part II of the keynote demo here.
Want more? Check out all the great SQL Server 2012 presentations, demos and labs at http://bit.ly/sql2012cookbook.
Presentation: Introducing High Availability and Disaster Recovery with SQL Server 2012 AlwaysOn
@services house:glad you like it!
Demo: A First Look at SQL Server Data Tools
@lsjames:I'd have to dig into your scenario a bit to answer this fully. In general, DAC upgrade will try the most minimally invastive upgrade strategy possible. I'm a bit suprised that it's messing with users, are you using DAC Fx 3.0 (that ships with RTM SQL 2012)?
Demo: A First Look at SQL Server Data Tools
@Borum.NET: thanks for the comments! Here's some answers to your questions:
Q: Is there a managed API (like the SQL SMO) that allows us to include dacpac files in our own installer and subsequently deploy (clean install / upgrade) to on premise SQL Server or SQL Azure?
A: DAC Fx has an API surface, check out http://sqldacexamples.codeplex.com
Q: The scenario I'm thinking of is having a single SQL Server Data Tools project as part of our solution and using TFS builds output dacpac files for SQL Server or SQL Azure (i.e. targetting the two different environments via configuration and then build the dacpacs). Is that possible?
A: Absolutely. Think of .dacpac and .bacpac as a single-file deployment capability for schema (.dacpac) and schema + data (.bacpac).
Demo: Exploring Self-Service Reporting with SQL Server 2012 Power View
Check out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
Presentation: Exploring SQL Server 2012 Power View
Check out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
Demo: Configuring Data Alerts with SQL Server 2012 Reporting Services
Check out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
Presentation: Introducing SQL Server 2012 Reporting Services Improvements
Check out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
Demo: Exploring SQL Server 2012 Analysis Services DAX Improvements
Check out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.