0

The only option i could find in the Azure Portal, is to export a copy of my database to a azure storage account which i don't have. So i wonder, is there any other way of exporting my database to my laptop machine?

Jo Smo
  • 6,923
  • 9
  • 47
  • 67
  • 1
    just curious about not having a storage account. Given that they're free to create. Is there a specific issue/reason? – David Makogon Jun 15 '16 at 22:28
  • Thank you for telling me. I just assumed that they are not free. :D – Jo Smo Jun 15 '16 at 22:31
  • 1
    Yup - trivial to create. *Note - you still pay for storage used, which runs a few pennies / gb / month. But if all you're doing is storing or transferring the occasional backup...* – David Makogon Jun 15 '16 at 22:33

1 Answers1

1

You may use SQL Server Management Studio for that - creating BACPAC and saving that to the local disk is the common solution for backing the database up.

Alex Belotserkovskiy
  • 4,012
  • 1
  • 13
  • 10
  • Can i export everything this way? Like Column properties, constraints, keys, stored procedures, triggers or only the data in my tables? – Jo Smo Jun 15 '16 at 21:28
  • 1
    "A BACPAC is a related artifact that encapsulates the database schema as well as the data stored in the database." [MSDN](https://msdn.microsoft.com/en-us/library/ee210546.aspx). And more relevant link than i used in the answer - https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate-compatible-export-bacpac-ssms/ – Alex Belotserkovskiy Jun 15 '16 at 21:32
  • 1
    And that [SO question](http://stackoverflow.com/questions/5475306/how-do-i-copy-sql-azure-database-to-my-local-development-server) is good as well (ve-e-ery old, but has a detailed information and some approaches that may be used even now). – Alex Belotserkovskiy Jun 15 '16 at 21:34
  • I've seen that one. That's why i asked if "everything" gets exported the way you suggested. I have already exported it successfully the way you suggested it. Thank you. :) – Jo Smo Jun 15 '16 at 22:24