CODEWITHSUNDEEP
sqlazureazure-sql-databasessms
Rennos
Rennos

Reputation: 93

SQL Server 2012 Management Studio no attach option for mdf files

I am trying to attach a database to my Azure SQL using Management Studio 2012. However, there is no "Attach" option when I click on the Databases folder on the server. Could anyone make some suggestions how to attach a .mdf file ?

Upvotes: 0

Views: 439

Answers (2)

JuneT
JuneT

Reputation: 7860

you cannot attach an .mdf directly to Azure SQL Database. neither can you restore a backup (.bak).

you can follow what sqluser pointed out above.

there's also other options like using Migration Wizard, bacpac, etc...

have a look here

Upvotes: 2

sqluser
sqluser

Reputation: 5672

Right click on your database ==> Tasks ==> Deploy database to SQL Azure

enter image description here

Upvotes: 0

Related Questions