CODEWITHSUNDEEP
sql-serverazureazure-sql-database
user9993
user9993

Reputation: 6170

Uploading database to Azure SQL

I need to upload an MDF file to Azure SQL. According to Is it possible to attach a MDF file to an Azure SQL database? the correct way to do this is to import the MDF to SQL Server Management Studio and then right click and export it to Azure SQL.

However all I'm getting is an error claiming that: enter image description here

I have no idea what this actually means nor why I am unable to upload the database to Azure. Any suggestions?

Upvotes: 0

Views: 464

Answers (3)

Kim Hoang
Kim Hoang

Reputation: 1368

Another way is using this tool. http://sqlazuremw.codeplex.com/ It will generate the script from your local database and execute it on Azure Sql.

Upvotes: 0

Martin Noreke
Martin Noreke

Reputation: 4136

In order to import a Database to Azure, you will need to create a BACPAC file. Instructions can be found in this MSDN blog post.

And just in case you run into it, this question has some good links for where to get the SQL Server Data Tools required to import a BACPAC from Azure. You probably need to get those installed before being able to export to BACPAC.

Update: Adding this so you can see my export options: enter image description here

Upvotes: 1

bryangm
bryangm

Reputation: 163

This message means that you will need to create a Windows VM within Azure that has a full install of SQL Server on it.

https://msdn.microsoft.com/en-us/library/azure/jj823132.aspx

Upvotes: 0

Related Questions