Cannot deploy VS 2010 database solution to database if the deployed database was manually deleted -
i working on creating visual studio database solution deploy databases in more managed manner. next steps performed after adding sample tables , sps in solution.
deploy database local machine (and new database created). add mock info tables in ssms. add couple of columns 1 of tables in vs 2010 solution. build solution , deploy database 1 time again (this time deploys changes made schema). verfiy existing info intact , new columns have been added table schema.everything working expected till point.
now delete database manually created deployment.go vs 2010 , deploy solution (expecting should clean deployment of database), next error :
------ deploy started: project: mydatabase, configuration: debug cpu ------
pre-deploy: starting script execution…
pre-deploy: finished script execution.
mydatabase.dacpac(0,0): error : -->cannot upgrade dac database mydatabase, database name not exist. specify valid database name.
is there setting in solution specify deployment should clean install if database not exist?
or
do need write separate (database creation) scripts if database not exist?
i ran issue well. deleted database , not deploy again. found link. dac application needs deleted in sql server management studio.
http://msdn.microsoft.com/en-us/library/ee240822.aspx
to delete dac application in sql server management studio connect database expand management node. expand data-tier applications node. right-click dac deleted, , select delete data-tier application… finish wizard dialogs:
i deleted application , able deploy again. still learning dac application.
database visual-studio-2010 deployment dac
No comments:
Post a Comment