Deleting temp DB in data tier application

Question

I have just started to use Data tier application in VS 2010.

Problem that I am facing is every time I deploy the project it creates a temp DB at the destination server with the name <MY_DB>_1_0_0_0__129586620060071225 and move the DB after that. But its not deleting the temp DB. So after every deployment a new temp db is getting created. How should I delete that using project, or is there any configuration needs to be done for that.

 

Thanks in advance.

Samagra

Answer 1

Hi Samagra,

 

Have you upgraded to VS 2010 SP1?  If not, I recommend you do so so that the schema deployments (upgrades) are all done in the target database.  The version of the DAC framework that shipped with VS 2010 RTM does side by side upgrades which result in a temporary database which is what I believe you are experiencing.

Answer 2

Hi Samagra,

Did you get a chance to test this with SP1 ? are you still getting this issue ?

Thanks,
Sunil

 

Answer 3

Hi Sunil,

I have not tried this. I have chosen to delete the temp DB as we are having live application and I dont wanna take risk with the application by upgrading the VS.

Thanks,

Samagra