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
Post a Comment