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 ?
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.