{"id":2007,"date":"2020-06-01T19:42:03","date_gmt":"2020-06-01T19:42:03","guid":{"rendered":"http:\/\/manualsqlserver.com\/?p=2007"},"modified":"2020-06-01T19:42:04","modified_gmt":"2020-06-01T19:42:04","slug":"importar-una-base-de-datos-de-azure-a-sql-server","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=2007","title":{"rendered":"Importar una base de datos de Azure a SQL Server"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"220\" height=\"242\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL__D.png\" alt=\"\" class=\"wp-image-2008\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Importar una base de datos de  un contenedor Azure a SQL Server<\/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. (<a href=\"https:\/\/manualsqlserver.com\/?p=1987\" target=\"_blank\" rel=\"noreferrer noopener\">Ver Exportar una base de datos del SQL a Azure<\/a>)<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>En este art\u00edculo se explica como importar una base de datos desde un formato BacPac almacenado en un contenedor de Azure hacia una instancia 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 importar la base de datos hacia SQL Server<\/figcaption><\/figure>\n\n\n\n<p>Base de datos en formato Bacpac exportada a un contenedor Azure.<\/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_Bacpac_Azure_SQL_01.png\" alt=\"\" class=\"wp-image-2009\" width=\"882\" height=\"408\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_01.png 748w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_01-300x139.png 300w\" sizes=\"auto, (max-width: 882px) 100vw, 882px\" \/><\/figure>\n\n\n\n<p style=\"font-size:24px\"><strong>Importar la base de datos del contenedor Azure a  SQL Server<\/strong><\/p>\n\n\n\n<p>Para importar la base de datos a SQL Server desde 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  pulsar bot\u00f3n derecho en \u00abBases de datos\u00bb (Databases) y luego seleccionar  \u00ab<strong>Importar  capa de datos de <strong>aplicaci\u00f3n<\/strong><\/strong>\u00bb (Import 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_Bacpac_Azure_SQL_02.png\" alt=\"\" class=\"wp-image-2010\" width=\"581\" height=\"762\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_02.png 457w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_02-229x300.png 229w\" sizes=\"auto, (max-width: 581px) 100vw, 581px\" \/><\/figure>\n\n\n\n<p>2. Aparece la ventana del asistente para importar 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_Bacpac_Azure_SQL_03.png\" alt=\"\" class=\"wp-image-2011\" width=\"733\" height=\"666\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_03.png 664w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_03-300x273.png 300w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/figure>\n\n\n\n<p>3.  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>4. Escribir las credenciales de autenticaci\u00f3n al portal de Azure. <\/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>5. 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>6. Seleccionar la base de datos a importar que debe estar almacenada en el contenedor seleccionado.<\/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_Bacpac_Azure_SQL_07.png\" alt=\"\" class=\"wp-image-2013\" width=\"717\" height=\"453\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_07.png 519w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_07-300x190.png 300w\" sizes=\"auto, (max-width: 717px) 100vw, 717px\" \/><\/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_Bacpac_Azure_SQL_06.png\" alt=\"\" class=\"wp-image-2012\" width=\"800\" height=\"727\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_06.png 589w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_06-300x273.png 300w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p>7. Especificar el nombre de la nueva base de datos a crear. 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_Bacpac_Azure_SQL_08.png\" alt=\"\" class=\"wp-image-2014\" width=\"849\" height=\"772\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_08.png 589w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_08-300x273.png 300w\" sizes=\"auto, (max-width: 849px) 100vw, 849px\" \/><figcaption>Base de datos nueva llamada NorthwindAzure<\/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_Bacpac_Azure_SQL_09.png\" alt=\"\" class=\"wp-image-2015\" width=\"830\" height=\"755\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_09.png 589w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_09-300x273.png 300w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><figcaption>Resumen de las opciones de importaci\u00f3n<\/figcaption><\/figure>\n\n\n\n<p>9. Al finalizar deber\u00eda salir todo correcto. <\/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_Bacpac_Azure_SQL_10.png\" alt=\"\" class=\"wp-image-2016\" width=\"814\" height=\"740\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_10.png 589w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_10-300x273.png 300w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><figcaption>Importaci\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_Bacpac_Azure_SQL_11.png\" alt=\"\" class=\"wp-image-2017\" width=\"471\" height=\"831\" srcset=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_11.png 258w, https:\/\/manualsqlserver.com\/wp-content\/uploads\/2020\/06\/ManualSQL_Bacpac_Azure_SQL_11-170x300.png 170w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><figcaption>Base de datos NorthwindAzure en Micrososft SQL Server Management Studio<\/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>Importar una base de datos de un contenedor Azure a SQL Server 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=2007\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":2008,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[164],"tags":[225,196,226],"class_list":["post-2007","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mantenimcat","tag-bacpac","tag-import","tag-importar-base-de-datos","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/2007","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=2007"}],"version-history":[{"count":1,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/2007\/revisions"}],"predecessor-version":[{"id":2018,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/2007\/revisions\/2018"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/2008"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}