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 Monday, July 20, 2015 4:41 PM

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:

• Proposed as answer by Casey KarstMicrosoft employee, Moderator Tuesday, July 21, 2015 5:59 PM
• Unproposed as answer by Robert Auer 14 hours 33 minutes ago

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:

• Proposed as answer by Casey KarstMicrosoft employee, Moderator Tuesday, July 21, 2015 5:59 PM
• Unproposed as answer by Robert Auer 14 hours 45 minutes ago

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:

• Proposed as answer by Casey KarstMicrosoft employee, Moderator Tuesday, July 21, 2015 5:59 PM
• Unproposed as answer by Robert Auer Wednesday, July 22, 2015 4:35 PM

You cannot import a .mdf file into Azure SQL DB. If your goal is to get your database into Azure SQL DB, you will need to import it with a .bacpac.

I ended up using SSDT and got that to move the tables over. The login on that app is pretty confusing.

Thanks.

• Marked as answer by Robert Auer 10 hours 6 minutes ago

I ended up using SSDT and got that to move the tables over. The login on that app is pretty confusing.

Thanks.

• Marked as answer by Robert Auer 9 hours 54 minutes ago

I ended up using SSDT and got that to move the tables over. The login on that app is pretty confusing.

Thanks.

• Marked as answer by Robert Auer Wednesday, July 22, 2015 9:14 PM