Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it possible to attach a MDF file to an Azure SQL database?

I have just created an Azure Website and Linked SQL Database.

I have a SQL Server 2008 SP2 database on my local machine. Is it possible to detach the local .mdf file, FTP it to Azure and then attach it as a SQL database in Azure? The only other way is to export the scheme and load this, followed by the data.

In the absence of detaching and attaching DBs, I have come across "SQLAzureMW" which looks very useful in guiding me through this process.

Thank you in advance.

like image 537
SamJolly Avatar asked Dec 28 '13 12:12

SamJolly


1 Answers

You can deploy an database from Management studio to Azure.

Just use this wizard

like image 188
Kenneth M. Nielsen Avatar answered Sep 26 '22 15:09

Kenneth M. Nielsen