April 11, 2012 at 10:59 am
I extracted a Data Tier Application from an existing test database for a developer. The test database was populated with data.
The developer was able to use the .dacpac, make his necessary changes and has sent it back to me. When I attempt to deploy it, it's asking for a new database. My assumption was that the deployment would add/alter the objects in the existing database.
Did I assume incorrectly? As I've poured through the documentation on Books Online, I'm not seeing the ability to alter the existing database.
Anyone else gone through this? Do I need to script out the movement of the data from the original database to a newly created database?
TIA.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 12, 2012 at 12:26 pm
It sounds like you may be having trouble with the DAC upgrade process. Here is a link that may help.
April 12, 2012 at 2:01 pm
Thanks Jerry. Indeed, I did not register the database first as a data tier application then try and upgrade it. I kept reading the same areas in BOL and getting nowhere (my own fault)...found the whitepaper and finally got past it.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply