none
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.
    Sunday, January 23, 2011 9:09 PM

Answers

  • 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

    Monday, January 24, 2011 6:26 AM

All replies

  • 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

    Monday, January 24, 2011 6:26 AM
  • Thanks for your quick reply Edward, I will see to execute that by hand, unfortunately.
    Monday, January 24, 2011 10:06 AM