Menu
I'd like to export a DB from SQL Azure to a MDF-file so i can mount it on an own instance of SQL-server, but when i hit "export" in the Windows Azure managament tools, it want's me to export the database to the Azure Blob storage, and i just want to download it. How do i achieve this?
658
In SQL Server 2016 Management Studio, the process for getting an azure database to your local machine has been streamlined. Right click on the database you want to import, click Tasks > Export data-tier application, and export your database to a local .
In SQL Server Management Studio (SSMS), right-click on the Azure SQL Database that needs to be migrated, then click Tasks, and finally click on Deploy Database to Microsoft Azure SQL Database… In the Deploy Database Wizard, click Next, then click Connect to connect to the target / destination SQL Server Database.
Windows Azure Management Tools does not support SQL Azure. To manage SQL Azure, you can use SQL Azure portal or standard SQL Server tools. For example, to export a database from SQL Azure, You can use the standard SQL Server Management Studio (refer to http://blogs.msdn.com/b/sqlazure/archive/2010/05/19/10014014.aspx for more details). If you prefer a command line tool, you can use BCP (refer to http://blogs.msdn.com/b/sqlazure/archive/2010/05/21/10014019.aspx for more information).
85
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
