I created a web app with authentication and it works great locally. I need to move it up to my Azure account so that it can be used by others.

The problem is I followed an example which used an .mdf database, and this (to my knowledge) doesn't work on Azure. I have attempted to migrate the mdf databse to my Azure DB with no success.

Is there a resource or some way to convert the mdf database to an Azure database? I'm ok if I lose my current user data in the database - I just need a way to make this work.

• Moved by Neelesh RayMicrosoft contingent staff, Moderator Saturday, July 18, 2015 7:43 AM Moving Thread as related to SQL Database

Hey Robert,

Is this a one time move you want to make? If so, There are several ways to take your on-prem db to azure. You can try using a Bacpac (https://msdn.microsoft.com/en-us/library/azure/hh335292.aspx) , scripting out your database, or you can just right click on the database, select Tasks-> "Deploy Database to SQL Azure". 

• Edited by chava007 14 hours 27 minutes ago

Hey Robert,

Is this a one time move you want to make? If so, There are several ways to take your on-prem db to azure. You can try using a Bacpac (https://msdn.microsoft.com/en-us/library/azure/hh335292.aspx) , scripting out your database, or you can just right click on the database, select Tasks-> "Deploy Database to SQL Azure". 

• Edited by chava007 14 hours 39 minutes ago

Thanks for your reply. Yes this is a one time move. I right-clicked on my database in VS2013, but there is no "Deploy to SQL Azure when I right click on it. I'll check out BacPac.  Thanks.

If this is a one time move, you can check out this tool which may make it easier for you.

https://sqlazuremw.codeplex.com/

Or you can also deploy your database with SSMS: