Geek asks and answers

Azure SQL Export Database for Native Server

I would like to export the DB from Azure SQL to an MDF file so that I can mount it on my own instance of the SQL server, but when I click export in Windows Azure management tools, it wants me to export the database to Azure Blob , and I just want to download it. How do I achieve this?

+5
source share
1 answer

Windows Azure Management Tools do not support SQL Azure. You can use the SQL Azure portal or standard SQL Server tools to manage SQL Azure. For example, to export a database from SQL Azure, you can use the standard SQL Server Management Studio (for more details see http://blogs.msdn.com/b/sqlazure/archive/2010/05/19/10014014.aspx ). If you prefer a command line tool, you can use BCP (see http://blogs.msdn.com/b/sqlazure/archive/2010/05/21/10014019.aspx for more information).

+4
source

More articles:


All Articles