deploying a data tier project on azure - pre and post deployment use the master DB

Question

Hello,

I'm using a Data Tier DB project to deploy on Azure, everything goes fine, the DB and the schema are well created except that during the pre and post deployment it always tries to use the master DB instead of the one I specified under "Deploy - Data Tier Application Instance Name" in the properties. I tried to use a USE MyDB statement but it is not supported.

Of course I would like the pre and post deployment scripts to be executed on the current DB I'm creating. Any idea ?

Thanks a lot

Best regards.

Answer 1

Hi,

Unfortunately not all Visual Studio Data Base projects features work with SQL Azure deployment. The one you encountered is one of them. As far as I know there is no workaround so I am afraid you have to execute those steps by hand.

Hope this helps.

Edward

Answer 2

Thanks for your quick reply Edward, I will see to execute that by hand, unfortunately.