Deploy a data tier application

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

    Yeah, well...The Dude abides.
  • It sounds like you may be having trouble with the DAC upgrade process. Here is a link that may help.

    http://msdn.microsoft.com/en-us/library/ee635209.aspx

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

    Yeah, well...The Dude abides.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply