Download an entire SQL Azure database as single file -


is there facility in azure copy of database? or rather, detach mdf , file? on occasion create database in cloud, it's while, , want take down , archive it. current rutine copies database using sql azure migration wizard local express instance, detach , put in safe place.

edit interestingly method of choice throws exception time around. it's far ideal.

there way it:

"c:\program files (x86)\microsoft sql server\110\dac\bin\sqlpackage.exe" /action:export /sourceservername:"tcp:xxxxx.database.windows.net,1433" /sourcedatabasename:dbname /sourceuser:user /sourcepassword:password /targetfile:c:\backups\backup.bacpac 

Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -