7

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.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
SamJolly
  • 6,347
  • 13
  • 59
  • 125

1 Answers1

13

You can deploy an database from Management studio to Azure.

Just use this wizard

Kenneth M. Nielsen
  • 487
  • 4
  • 5
  • Kenneth, thank you for this. What version are you using. I have to admit I am on 2008 sp2 Management Studio, and I do not see your Azure options. – SamJolly Dec 28 '13 at 14:45
  • Just download the latest management studio from Microsoft, i'm on sql 2012 – Kenneth M. Nielsen Dec 28 '13 at 23:53
  • Kenneth, I have been playing around with MS's SSDT schema and Data compare tool from within VS2012. It is good. So this is another option. I will try yours as well. Many thanks. – SamJolly Dec 29 '13 at 03:34
  • Is it also possible to migrate an older version of `.mdf` file using a newer version of SSMS? – NeWi-SL Feb 04 '22 at 14:28