{"id":1987,"date":"2020-06-01T17:51:24","date_gmt":"2020-06-01T17:51:24","guid":{"rendered":"http:\/\/manualsqlserver.com\/?p=1987"},"modified":"2020-06-01T19:44:27","modified_gmt":"2020-06-01T19:44:27","slug":"exportar-una-base-de-datos-a-azure-storage","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=1987","title":{"rendered":"Exportar una base de datos a Azure Storage"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"220\" height=\"220\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure__D.png\" alt=\"\" class=\"wp-image-1988\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure__D.png 220w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure__D-150x150.png 150w\" sizes=\"auto, (max-width: 220px) 100vw, 220px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Exportar una base de datos de SQL Server a un contenedor Azure<\/h2>\n\n\n\n<p>Microsoft ofrece muchas posibilidades de almacenamiento de infomaci\u00f3n en la nube, dentro de las formas de implementaci\u00f3n de los servicios de Azure (IaaS, PaaS y SaaS). Una forma sencilla y muy segura es almacenar copias de seguridad de las bases de datos de SQL Server en un contenedor de una cuenta de almacenamiento de Azure.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>En este art\u00edculo se explica como guardar en un formato BacPac la base de datos de SQL Server. El formato BacPac es el formato de las copias de seguridad de las bases de datos de SQL Server exportadas a un contenedor de Azure.<\/p>\n\n\n\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-2636008503986218\" data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<p style=\"font-size:24px\"><strong>Contenedor de Azure<\/strong><\/p>\n\n\n\n<p>Un contenedor de Azure se puede crear en una cuenta de almacenamiento de Microsoft Azure, para ello se tiene que tener una cuenta con la que se deba conectar.<\/p>\n\n\n\n<p>La cuenta de almacenamiento se crea en el Portal Azure accediendo a Cuentas de Almacenamiento.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_01.png\" alt=\"\" class=\"wp-image-1989\" width=\"734\" height=\"439\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_01.png 676w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_01-300x180.png 300w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><figcaption>Cuenta de almacenamiento de Azure<\/figcaption><\/figure>\n\n\n\n<p>Una vez creada la cuenta de almacenamiento se debe seleccionar el recurso<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_02.png\" alt=\"\" class=\"wp-image-1990\" width=\"875\" height=\"328\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_02.png 831w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_02-300x113.png 300w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_02-768x288.png 768w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><figcaption>Cuenta de almacenamiento llamada <strong>flsazurestorage<\/strong><\/figcaption><\/figure>\n\n\n\n<p>En la cuenta de almacenamiento, se crea un Contenedor<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_03.png\" alt=\"\" class=\"wp-image-1991\" width=\"862\" height=\"529\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_03.png 710w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_03-300x184.png 300w\" sizes=\"auto, (max-width: 862px) 100vw, 862px\" \/><figcaption>Contenedores Azure<\/figcaption><\/figure>\n\n\n\n<p>Para este ejemplo se ha creado el contenedor llamado <strong>container-fls-azure<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_04.png\" alt=\"\" class=\"wp-image-1992\" width=\"878\" height=\"309\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_04.png 762w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_04-300x106.png 300w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><figcaption>Contenedor para exportar la base de datos de SQL Server<\/figcaption><\/figure>\n\n\n\n<p style=\"font-size:24px\"><strong>Exportar la base de datos de SQL Server a Azure<\/strong><\/p>\n\n\n\n<p>Para exportar la base de datos de SQL Server a un contendor de Azure se siguen los pasos siguientes:<\/p>\n\n\n\n<p>1. En el explorador de objetos de Microsoft SQL Server Management Studio seleccionar la base de datos a exportar, pulsar bot\u00f3n derecho en la base de datos y luego seleccionar \u00ab<strong>Tareas<\/strong>\u00bb (Tasks), luego \u00ab<strong>Exportar aplicaci\u00f3n de capa de datos<\/strong>\u00bb (Export Data-tier  Application&#8230;)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_05.png\" alt=\"\" class=\"wp-image-1993\" width=\"703\" height=\"921\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_05.png 484w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_05-229x300.png 229w\" sizes=\"auto, (max-width: 703px) 100vw, 703px\" \/><\/figure>\n\n\n\n<p>2. Aparece la ventana del asistente para exportar base de datos. Pulsar <strong>Siguiente<\/strong> (Next)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_06.png\" alt=\"\" class=\"wp-image-1994\" width=\"783\" height=\"709\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_06.png 643w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_06-300x272.png 300w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<p>3. Especificar las opciones de exportaci\u00f3n, seleccionar para este caso la opci\u00f3n \u00ab<strong>Guardar en Micrososft Azure<\/strong>\u00bb (Save to Microsoft Azure) y pulsar el bot\u00f3n \u00ab<strong>Conectar<\/strong>\u00bb (Connect).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_07.png\" alt=\"\" class=\"wp-image-1996\" width=\"841\" height=\"764\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_07.png 591w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_07-300x273.png 300w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/figure>\n\n\n\n<p>4. Conectarse al portal de Micrososft Azure, pulsar \u00ab<strong>Iniciar sesi\u00f3n<\/strong>\u00bb (Sign In&#8230;)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_08.png\" alt=\"\" class=\"wp-image-1997\" width=\"797\" height=\"557\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_08.png 653w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_08-300x210.png 300w\" sizes=\"auto, (max-width: 797px) 100vw, 797px\" \/><\/figure>\n\n\n\n<p>5. Escribir las credenciales de autenticaci\u00f3n al portal de Azure. La cuenta.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_09.png\" alt=\"\" class=\"wp-image-1998\" width=\"715\" height=\"957\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_09.png 568w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_09-224x300.png 224w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/figure>\n\n\n\n<p>6. Una vez conectado, seleccionar la cuenta de almacenamiento y el contenedor. Pulsar Ok.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_10.png\" alt=\"\" class=\"wp-image-1999\" width=\"808\" height=\"561\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_10.png 644w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_10-300x209.png 300w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\" \/><\/figure>\n\n\n\n<p>7. Especificar las tablas que se van a exportar. Pulsar Siguiente (Next)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_11.png\" alt=\"\" class=\"wp-image-2000\" width=\"776\" height=\"707\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_11.png 613w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_11-300x274.png 300w\" sizes=\"auto, (max-width: 776px) 100vw, 776px\" \/><figcaption>Tablas a exportar a Azure<\/figcaption><\/figure>\n\n\n\n<p>8. Para realizar la exportaci\u00f3n pulsar <strong>Finalizar<\/strong> (Finish)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_12.png\" alt=\"\" class=\"wp-image-2001\" width=\"796\" height=\"724\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_12.png 590w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_12-300x273.png 300w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><figcaption>Resumen de las opciones de exportaci\u00f3n<\/figcaption><\/figure>\n\n\n\n<p>9. Al finalizar deber\u00eda salir todo correcto. En el contendor comprobar que la base de datos se haya exportado.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_13.png\" alt=\"\" class=\"wp-image-2002\" width=\"833\" height=\"758\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_13.png 616w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_13-300x273.png 300w\" sizes=\"auto, (max-width: 833px) 100vw, 833px\" \/><figcaption>Exportaci\u00f3n de la base de datos exitosa.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_14.png\" alt=\"\" class=\"wp-image-2003\" width=\"869\" height=\"383\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_14.png 748w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_BacpacSQL_Azure_14-300x132.png 300w\" sizes=\"auto, (max-width: 869px) 100vw, 869px\" \/><figcaption>Archivo NorthwindAzure.bacpac en el contenedor <strong>container-fls-azure<\/strong><\/figcaption><\/figure>\n\n\n\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-2636008503986218\" data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Exportar una base de datos de SQL Server a un contenedor Azure Microsoft ofrece muchas posibilidades de almacenamiento de infomaci\u00f3n en la nube, dentro de las formas de implementaci\u00f3n de los servicios de Azure (IaaS, PaaS y SaaS). Una forma sencilla y muy segura es almacenar copias de seguridad de las bases de datos de &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=1987\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1988,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[164],"tags":[223,224,222],"class_list":["post-1987","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mantenimcat","tag-azure","tag-export-data-tier","tag-exportar-base-de-datos","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/1987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1987"}],"version-history":[{"count":3,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/1987\/revisions"}],"predecessor-version":[{"id":2021,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/1987\/revisions\/2021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/1988"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}