{"id":1484,"date":"2025-02-08T22:21:00","date_gmt":"2025-02-09T01:21:00","guid":{"rendered":"https:\/\/ederlelis.com.br\/blog\/?p=1484"},"modified":"2025-02-08T22:21:07","modified_gmt":"2025-02-09T01:21:07","slug":"migracao-on-premise-para-azure-sql-parte2","status":"publish","type":"post","link":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte2\/","title":{"rendered":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE2)"},"content":{"rendered":"\n<p>Ol\u00e1, espero que voc\u00ea esteja bem!\u00a0\ud83d\ude09<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Dando continuidade \u00e0 nossa <strong>s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise<\/strong>.<\/p>\n\n\n\n<p>Se voc\u00ea ainda n\u00e3o leu o primeiro post da s\u00e9rie, d\u00ea uma olhada, ficou bem completo. Usei o m\u00e9todo \u201c<strong>Deploy Database to Microsoft Azure SQL Database<\/strong>\u201d, detalhando cada passo. <strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Voc\u00ea vai gostar!<\/span><\/strong> \ud83d\ude09<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ol><li><a rel=\"noreferrer noopener\" href=\"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte1\/\" data-type=\"URL\" data-id=\"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte1\/\" target=\"_blank\">Deploy Database to Microsoft Azure SQL Database (link do post)<\/a><\/li><\/ol>\n\n\n\n<p><\/p>\n\n\n\n<p>Hoje, nesta Parte 2, abordaremos o m\u00e9todo de migra\u00e7\u00e3o que utiliza o <strong>Backup BACPAC e Importa\u00e7\u00e3o<\/strong>. Este m\u00e9todo \u00e9 bastante utilizado, para <strong>transferir bancos de dados SQL Server para o Azure SQL Database<\/strong>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ol start=\"2\"><li><strong>Backup bacpac com import<\/strong><\/li><\/ol>\n\n\n\n<p>Tamb\u00e9m conhecido como \u201cexport x import\u201d, pois envolve exportar o banco como um arquivo<span class=\"has-inline-color has-black-color\"><strong> .bacpac<\/strong><\/span><span class=\"has-inline-color has-luminous-vivid-amber-color\"> <\/span>, em seguida import\u00e1-lo no Azure SQL Database.<\/p>\n\n\n\n<p>O formato <strong>BACPAC<\/strong> \u00e9 um arquivo que cont\u00e9m o esquema do banco de dados e seus dados, permitindo uma migra\u00e7\u00e3o &#8220;f\u00e1cil&#8221; e eficiente.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Vantagens:<\/strong><\/p>\n\n\n\n<ul><li><strong>Portabilidade<\/strong>: O arquivo .bacpac \u00e9 port\u00e1til, podendo ser movido facilmente entre diferentes servidores, ambientes ou at\u00e9 mesmo armazenado como backup.<\/li><li><strong>Controle de Tamanho e Escopo<\/strong>: Ele cont\u00e9m apenas o esquema e os dados (sem objetos de sistema), o que reduz o tamanho e simplifica a migra\u00e7\u00e3o.<\/li><li><strong>Suporte Amplamente Dispon\u00edvel<\/strong>: O m\u00e9todo \u00e9 suportado por ferramentas como SSMS e o Portal do Azure, proporcionando flexibilidade.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Desvantagens:<\/strong><\/p>\n\n\n\n<ul><li><strong>Limita\u00e7\u00f5es de Dados<\/strong>: Dados corrompidos, muito grandes ou incompat\u00edveis podem causar falhas durante a exporta\u00e7\u00e3o e\/ou importa\u00e7\u00e3o.<\/li><li><strong>Tempo de Processamento<\/strong>: Pode levar tempo para criar e importar o .bacpac, dependendo do tamanho do banco de dados.<\/li><li><strong>N\u00e3o Suporta Algumas Configura\u00e7\u00f5es Avan\u00e7adas<\/strong>: Configura\u00e7\u00f5es espec\u00edficas do servidor, como permiss\u00f5es de login, n\u00e3o s\u00e3o inclu\u00eddas no arquivo .bacpac.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>2.1 &#8211; Prepara\u00e7\u00e3o do Ambiente:<\/strong><\/p>\n\n\n\n<p>Assim como mencionado no post inicial, por seguran\u00e7a, \u00e9 bom sempre ter um backup atualizado antes de iniciar qualquer processo.<\/p>\n\n\n\n<p>E tamb\u00e9m certifique-se de que o banco de dados de origem \u00e9 compat\u00edvel com o Azure SQL Database, incluindo o suporte \u00e0s features utilizadas.<\/p>\n\n\n\n<p>Outro ponto importante saber:<\/p>\n\n\n\n<ul><li><strong>Espa\u00e7o Dispon\u00edvel<\/strong>: O .bacpac pode ocupar bastante espa\u00e7o dependendo do banco.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>2.2 &#8211; Exportar BACPAC:<\/strong><\/p>\n\n\n\n<ul><li>Abra o <strong>SQL Server Management Studio (SSMS)<\/strong> e conecte-se ao banco de dados de origem.<\/li><\/ul>\n\n\n\n<p>Neste exemplo vamos exportar a database <strong>AdventureWorks2014<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"231\" height=\"123\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac1-1.png?resize=231%2C123&#038;ssl=1\" alt=\"\" class=\"wp-image-1488\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac1-1.png?w=231&amp;ssl=1 231w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac1-1.png?resize=100%2C53&amp;ssl=1 100w\" sizes=\"(max-width: 231px) 100vw, 231px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<ul><li>Clique com o bot\u00e3o direito no banco de dados que deseja exportar.<\/li><\/ul>\n\n\n\n<p>V\u00e1 em <strong>Task<\/strong> > <strong>Export Data-tier Application<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"519\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?resize=640%2C519&#038;ssl=1\" alt=\"\" class=\"wp-image-1487\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?w=737&amp;ssl=1 737w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?resize=300%2C243&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?resize=700%2C568&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?resize=520%2C422&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?resize=360%2C292&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?resize=250%2C203&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac2.png?resize=100%2C81&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Siga as instru\u00e7\u00f5es do assistente:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"578\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=640%2C578&#038;ssl=1\" alt=\"\" class=\"wp-image-1489\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?w=822&amp;ssl=1 822w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=300%2C271&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=768%2C694&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=700%2C633&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=520%2C470&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=360%2C325&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=250%2C226&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac3.png?resize=100%2C90&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Tem-se duas op\u00e7\u00f5es para salvar o arquivo .bacpac :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"392\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=640%2C392&#038;ssl=1\" alt=\"\" class=\"wp-image-1490\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?w=809&amp;ssl=1 809w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=300%2C184&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=768%2C470&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=700%2C428&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=520%2C318&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=360%2C220&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=250%2C153&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac4.png?resize=100%2C61&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Op\u00e7\u00e3o1<\/span><\/strong><\/p>\n\n\n\n<p>Escolha <span style=\"font-size: revert; color: initial;\">uma pasta e de nome ao arquivo que deseja salvar.<\/span> <\/p>\n\n\n\n<p>Lembrando que o tamanho da base influenciar\u00e1 no tempo para salvar, e tamb\u00e9m \u00e9 necess\u00e1rio validar se voc\u00ea possui espa\u00e7o suficiente dispon\u00edvel no disco.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"530\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?resize=640%2C530&#038;ssl=1\" alt=\"\" class=\"wp-image-1491\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?w=706&amp;ssl=1 706w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?resize=300%2C249&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?resize=700%2C580&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?resize=520%2C431&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?resize=360%2C298&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?resize=250%2C207&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac5.png?resize=100%2C83&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Confira as informa\u00e7\u00f5es antes de prosseguir.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"284\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=640%2C284&#038;ssl=1\" alt=\"\" class=\"wp-image-1493\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?w=829&amp;ssl=1 829w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=300%2C133&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=768%2C341&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=700%2C311&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=520%2C231&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=360%2C160&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=250%2C111&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac6.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<ul><li>Pronto, o arquivo .bacpac ser\u00e1 salvo.<\/li><\/ul>\n\n\n\n<p>Ao confirmar, o exporting se iniciar\u00e1.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"238\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=640%2C238&#038;ssl=1\" alt=\"\" class=\"wp-image-1494\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?w=812&amp;ssl=1 812w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=300%2C112&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=768%2C286&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=700%2C260&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=520%2C193&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=360%2C134&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=250%2C93&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac7.png?resize=100%2C37&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Conclu\u00eddo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"582\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=640%2C582&#038;ssl=1\" alt=\"\" class=\"wp-image-1495\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?w=812&amp;ssl=1 812w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=300%2C273&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=768%2C699&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=700%2C637&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=520%2C473&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=360%2C328&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=250%2C228&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac8.png?resize=100%2C91&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Arquivo salvo em disco local.<\/p>\n\n\n\n<p>Observa que neste nosso exemplo o arquivo possui em tamanho \u201cmin\u00fasculo\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"481\" height=\"90\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac9.png?resize=481%2C90&#038;ssl=1\" alt=\"\" class=\"wp-image-1496\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac9.png?w=481&amp;ssl=1 481w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac9.png?resize=300%2C56&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac9.png?resize=360%2C67&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac9.png?resize=250%2C47&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac9.png?resize=100%2C19&amp;ssl=1 100w\" sizes=\"(max-width: 481px) 100vw, 481px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Simples n\u00e9, concorda? Mas no dia a dia nem tudo \u00e9 maravilha. <br>Como dizem: Pra que facilitar se podemos complicar!? Algo assim \u2026. rsrs<\/span><\/strong><\/p>\n\n\n\n<p>Databases geralmente s\u00e3o grandes e esse processo de salvar no servidor local, nem sempre vai ser poss\u00edvel devido ao espa\u00e7o em discos dispon\u00edveis.<\/p>\n\n\n\n<p>Outro ponto importante \u00e9 o hardware e a rede, que podem impactar, fazendo com que demore muito a conclus\u00e3o do download e\/ou upload de arquivo.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Sendo assim, que tal salvar esse arquivo diretamente no Azure? Facilitando depois nosso import. Bora!?<\/span><\/strong> \ud83d\ude09<\/p>\n\n\n\n<p><strong>2.3 &#8211; Storage Account<\/strong><\/p>\n\n\n\n<p><strong>Acesse o Portal do Azure<\/strong><\/p>\n\n\n\n<ul><li>Entre no portal do Azure: <a href=\"https:\/\/portal.azure.com\/\"><\/a><a rel=\"noreferrer noopener\" href=\"https:\/\/portal.azure.com\" target=\"_blank\">https:\/\/portal.azure.com<\/a>.<\/li><li>Fa\u00e7a login na sua conta.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>Para seguir, vamos usar um s<strong>torage Account.<\/strong><\/p>\n\n\n\n<ul><li><strong>Criar um Storage Account (ou use um seu, caso j\u00e1 tenha criado)<\/strong><ul><li><strong>Acesse o servi\u00e7o de Storage Accounts<\/strong><\/li><li>No menu esquerdo, clique em <strong>&#8220;Storage accounts&#8221;<\/strong>.<\/li><li>Clique em <strong>&#8220;Create&#8221;<\/strong><\/li><\/ul><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"588\" height=\"354\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac10.png?resize=588%2C354&#038;ssl=1\" alt=\"\" class=\"wp-image-1497\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac10.png?w=588&amp;ssl=1 588w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac10.png?resize=300%2C181&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac10.png?resize=520%2C313&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac10.png?resize=360%2C217&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac10.png?resize=250%2C151&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac10.png?resize=100%2C60&amp;ssl=1 100w\" sizes=\"(max-width: 588px) 100vw, 588px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Configure as informa\u00e7\u00f5es b\u00e1sicas<\/strong>:<\/p>\n\n\n\n<ul><li><strong>Subscription<\/strong>: Selecione a assinatura onde o Storage Account ser\u00e1 criado.<\/li><li><strong>Resource Group<\/strong>: Crie um novo grupo de recursos ou selecione um existente.<\/li><li><strong>Storage Account Name<\/strong>: Defina um nome \u00fanico para o Storage Account (deve ser em letras min\u00fasculas e sem caracteres especiais).<\/li><li><strong>Region<\/strong>: Escolha a regi\u00e3o mais pr\u00f3xima para melhor desempenho.<\/li><li><strong>Performance<\/strong>: Escolha &#8220;Standard&#8221; (geralmente suficiente para uploads).<\/li><li><strong>Redund\u00e2ncia<\/strong>: Escolha uma op\u00e7\u00e3o de redund\u00e2ncia (ex.: LRS, ZRS, etc.).<\/li><\/ul>\n\n\n\n<p><strong>OBS<\/strong>: Escolha as op\u00e7\u00f5es que melhor atendam \u00e0s suas necessidades, considerando fatores como frequ\u00eancia de acesso, performance requerida e custo estimado, pois essas escolhas impactam diretamente tanto o desempenho quanto o or\u00e7amento do seu projeto.<\/p>\n\n\n\n<p><strong>Para este lab optei por estas:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"618\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=640%2C618&#038;ssl=1\" alt=\"\" class=\"wp-image-1498\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?w=831&amp;ssl=1 831w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=300%2C290&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=768%2C742&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=700%2C676&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=520%2C502&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=360%2C348&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=250%2C242&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac11.png?resize=100%2C97&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Clique em &#8220;Next&#8221;<\/strong> at\u00e9 chegar ao final e clique em <strong>&#8220;Review + Create&#8221;<\/strong>.<\/p>\n\n\n\n<ul><li>Revise as configura\u00e7\u00f5es e clique em <strong>&#8220;Create&#8221;<\/strong>.<\/li><\/ul>\n\n\n\n<p>Deploy conclu\u00eddo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"229\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=640%2C229&#038;ssl=1\" alt=\"\" class=\"wp-image-1499\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=1024%2C367&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=300%2C107&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=768%2C275&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=700%2C251&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=520%2C186&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=360%2C129&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=250%2C90&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?resize=100%2C36&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?w=1354&amp;ssl=1 1354w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac12.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>2.4 &#8211; Blob Container<\/strong><\/p>\n\n\n\n<p>Vamos precisar agora criar um blob container.<\/p>\n\n\n\n<ul><li>No Storage Account rec\u00e9m-criado, pesquise por <strong>Containers<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"630\" height=\"386\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac13.png?resize=630%2C386&#038;ssl=1\" alt=\"\" class=\"wp-image-1500\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac13.png?w=630&amp;ssl=1 630w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac13.png?resize=300%2C184&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac13.png?resize=520%2C319&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac13.png?resize=360%2C221&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac13.png?resize=250%2C153&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac13.png?resize=100%2C61&amp;ssl=1 100w\" sizes=\"(max-width: 630px) 100vw, 630px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<ul><li>Clique e v\u00e1 em <strong>&#8220;+ Container&#8221;<\/strong>.<ul><li><strong>Nome<\/strong>: Defina um nome para o container (ex.: upbacpac).<\/li><li><strong>Public access level<\/strong>: Escolha <strong>&#8220;Private (no anonymous access)&#8221;<\/strong> (mais seguro) ou <strong>&#8220;Blob (public read access for blobs only)&#8221;<\/strong> se deseja que os arquivos sejam acess\u00edveis publicamente.<\/li><li>Clique em <strong>&#8220;Create&#8221;<\/strong>.<\/li><\/ul><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"423\" height=\"199\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac14.png?resize=423%2C199&#038;ssl=1\" alt=\"\" class=\"wp-image-1501\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac14.png?w=423&amp;ssl=1 423w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac14.png?resize=300%2C141&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac14.png?resize=360%2C169&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac14.png?resize=250%2C118&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac14.png?resize=100%2C47&amp;ssl=1 100w\" sizes=\"(max-width: 423px) 100vw, 423px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Conclu\u00eddo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"111\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=640%2C111&#038;ssl=1\" alt=\"\" class=\"wp-image-1502\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=1024%2C177&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=300%2C52&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=768%2C133&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=700%2C121&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=520%2C90&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=360%2C62&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=250%2C43&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?resize=100%2C17&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?w=1336&amp;ssl=1 1336w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac15.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Por padr\u00e3o, o <strong>Azure Blob Storage<\/strong> requer um m\u00e9todo de autentica\u00e7\u00e3o para permitir uploads. Portanto, como vamos enviar um arquivo <strong>.bacpac<\/strong> para o <strong>Blob Container<\/strong>, precisaremos configurar <strong>permiss\u00f5es de acesso<\/strong>.<\/p>\n\n\n\n<p>Temos algumas op\u00e7\u00f5es:<\/p>\n\n\n\n<ul><li><strong>Usar um Storage Account Key (Menos Seguro)<\/strong><\/li><\/ul>\n\n\n\n<p>Podemos usar para autenticar o upload, mas n\u00e3o \u00e9 recomendado para acesso compartilhado. <strong>A Storage Account Key funciona<\/strong>, mas d\u00e1 <strong>acesso total \u00e0 conta de armazenamento<\/strong>, o que pode ser um risco.<\/p>\n\n\n\n<ul><li><strong>Definir o Blob como P\u00fablico (Menos Seguro)<\/strong><\/li><\/ul>\n\n\n\n<p>Se quiser permitir uploads <strong>sem autentica\u00e7\u00e3o<\/strong>, pode alterar o <strong>Blob Container para acesso p\u00fablico<\/strong>, mas isso exp\u00f5e o armazenamento a acessos n\u00e3o controlados, devendo ser evitado principalmente para dados sens\u00edveis.<\/p>\n\n\n\n<ul><li><strong>Usar um SAS Token (M\u00e9todo Recomendado)<\/strong><\/li><\/ul>\n\n\n\n<p>Ao inv\u00e9s de alterar permiss\u00f5es globais, pode gerar um <strong>SAS Token<\/strong> para permitir uploads tempor\u00e1rios.<\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Afinal de conta, qual m\u00e9todo usar?<\/span><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"122\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?resize=640%2C122&#038;ssl=1\" alt=\"\" class=\"wp-image-1503\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?w=719&amp;ssl=1 719w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?resize=300%2C57&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?resize=700%2C133&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?resize=520%2C99&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?resize=360%2C69&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?resize=250%2C48&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac16.png?resize=100%2C19&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>O SAS Token (Shared Access Signature) \u00e9 o m\u00e9todo mais seguro e flex\u00edvel<\/strong> para permitir uploads de arquivos <strong>.bacpac<\/strong> no Blob Storage.<\/p>\n\n\n\n<p>Este m\u00e9todo <strong>n\u00e3o \u00e9 ativado por padr\u00e3o<\/strong>, portanto, precisamos <strong>gerar um SAS Token<\/strong> antes de realizar o upload.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>2.5 &#8211; Gerar um SAS Token (Shared Access Signature)<\/strong><\/p>\n\n\n\n<ul><li>No <strong>Azure Portal<\/strong>, acesse o <strong>Storage Account<\/strong> e v\u00e1 at\u00e9 <strong>&#8220;Shared access signature&#8221;<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"300\" height=\"348\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac17.png?resize=300%2C348&#038;ssl=1\" alt=\"\" class=\"wp-image-1504\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac17.png?w=300&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac17.png?resize=259%2C300&amp;ssl=1 259w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac17.png?resize=250%2C290&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac17.png?resize=100%2C116&amp;ssl=1 100w\" sizes=\"(max-width: 300px) 100vw, 300px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Configure as op\u00e7\u00f5es:<\/p>\n\n\n\n<ul><li><strong>Permiss\u00f5es<\/strong>: Marque <strong>Write<\/strong>, <strong>Read<\/strong>, e <strong>Create<\/strong> (para permitir upload e leitura do arquivo).<\/li><li><strong>Start and Expiry date\/time<\/strong>: Defina um per\u00edodo de validade seguro.<\/li><li>Clique em <strong>&#8220;Generate SAS and connection string&#8221;<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"419\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?resize=640%2C419&#038;ssl=1\" alt=\"\" class=\"wp-image-1505\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?w=769&amp;ssl=1 769w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?resize=300%2C196&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?resize=700%2C458&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?resize=520%2C340&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?resize=360%2C235&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?resize=250%2C164&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac18.png?resize=100%2C65&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<ul><li>Copie a <strong>Blob service SAS URL<\/strong>, pois ela ser\u00e1 usada para o upload.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"161\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=640%2C161&#038;ssl=1\" alt=\"\" class=\"wp-image-1506\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=1024%2C257&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=300%2C75&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=768%2C193&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=700%2C175&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=520%2C130&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=360%2C90&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=250%2C63&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?resize=100%2C25&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac19.png?w=1085&amp;ssl=1 1085w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>2.6 &#8211; Fazer upload com o SAS Token (Exemplo via AzCopy):<\/strong><\/p>\n\n\n\n<p>Vamos testar se o AzCopy est\u00e1 instalado.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>azcopy --version<\/code><\/pre>\n\n\n\n<p>N\u00e3o reconhecido.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"106\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=640%2C106&#038;ssl=1\" alt=\"\" class=\"wp-image-1507\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?w=820&amp;ssl=1 820w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=300%2C50&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=768%2C127&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=700%2C116&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=520%2C86&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=360%2C60&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=250%2C41&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac20.png?resize=100%2C17&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Vamos baixar ele e instalar. Seguindo passos no site da microsoft.<\/p>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/pt-br\/azure\/storage\/common\/storage-use-azcopy-v10?tabs=zypper\" target=\"_blank\" rel=\"noreferrer noopener\">Copiar ou mover dados para o Armazenamento do Microsoft Azure com o AzCopy v10 | Microsoft Learn<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"564\" height=\"120\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac21.png?resize=564%2C120&#038;ssl=1\" alt=\"\" class=\"wp-image-1508\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac21.png?w=564&amp;ssl=1 564w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac21.png?resize=300%2C64&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac21.png?resize=520%2C111&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac21.png?resize=360%2C77&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac21.png?resize=250%2C53&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac21.png?resize=100%2C21&amp;ssl=1 100w\" sizes=\"(max-width: 564px) 100vw, 564px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Executaremos ele seguindo diret\u00f3rio que foi salvo o exe.<\/p>\n\n\n\n<p><em>PS C:\\Users\\vagrant\\Downloads\\azcopy> .\\azcopy.exe<\/em><\/p>\n\n\n\n<p><strong>Instala\u00e7\u00e3o conclu\u00edda.<\/strong><\/p>\n\n\n\n<p>Validando vers\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"375\" height=\"45\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac22.png?resize=375%2C45&#038;ssl=1\" alt=\"\" class=\"wp-image-1509\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac22.png?w=375&amp;ssl=1 375w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac22.png?resize=300%2C36&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac22.png?resize=360%2C43&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac22.png?resize=250%2C30&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac22.png?resize=100%2C12&amp;ssl=1 100w\" sizes=\"(max-width: 375px) 100vw, 375px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Agora estamos apto a fazer o upload do bacpac via script no powershell.<\/p>\n\n\n\n<p>Enviando o arquivo <strong>.bacpac<\/strong> para meu <strong>Blob Storage.<\/strong><\/p>\n\n\n\n<p>Segue script padr\u00e3o. Basta substituir os campos conforme seu portal.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>azcopy copy<\/strong> \"C:\\caminho\\<strong>seuarquivo<\/strong>.bacpac\" \"https:\/\/&lt;<strong>NOME_STORAGE_ACCOUNT<\/strong>>.blob.core.windows.net\/&lt;<strong>CONTAINER_NAME<\/strong>>\/<strong>seuarquivo<\/strong>.bacpac?&lt;<strong>SAS_TOKEN<\/strong>>\"\r\n<\/code><\/pre>\n\n\n\n<p>Este vai ser o meu script:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\r\nazcopy copy \"C:\\Users\\vagrant\\Downloads\\bacpac_20250204\\bacpac_20250204.bacpac\" \"https:\/\/stabacpac.blob.core.windows.net\/upbacpac\/bacpac_20250204.bacpac?sv=2022-11-02&amp;ss=bfqt&amp;srt=sco&amp;sp=rwdlacupuytfx&amp;se=2025-02-06T09:17:35Z&amp;st=2025-02-05T01:17:35Z&amp;spr=https&amp;sig=aKe5NUGcs45UTCi%2FogBGr2xftyej1PYz8JGhquE3UPs%3D\"<\/code><\/pre>\n\n\n\n<p><strong>Solu\u00e7\u00e3o R\u00e1pida: Rodar o AzCopy Diretamente<\/strong><\/p>\n\n\n\n<p>Como alternativa imediata, tente rodar o comando utilizando o <strong>caminho completo do execut\u00e1vel<\/strong>, assim:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\Users\\vagrant\\Downloads\\azcopy> C:\\Users\\vagrant\\Downloads\\azcopy\\azcopy copy \"C:\\Users\\vagrant\\Downloads\\bacpac_20250204\\bacpac_20250204.bacpac\" \"https:\/\/stabacpac.blob.core.windows.net\/upbacpac\/bacpac_20250204.bacpac?sv=2022-11-02&amp;ss=bfqt&amp;srt=sco&amp;sp=rwdlacupuytfx&amp;se=2025-02-06T09:17:35Z&amp;st=2025-02-05T01:17:35Z&amp;spr=https&amp;sig=aKe5NUGcs45UTCi%2FogBGr2xftyej1PYz8JGhquE3UPs%3D\"<\/code><\/pre>\n\n\n\n<p>Em pouco tempo o upload foi conclu\u00eddo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"343\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=640%2C343&#038;ssl=1\" alt=\"\" class=\"wp-image-1510\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?w=805&amp;ssl=1 805w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=300%2C161&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=768%2C412&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=700%2C376&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=520%2C279&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=360%2C193&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=250%2C134&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac23.png?resize=100%2C54&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Arquivo inserido.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"168\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=640%2C168&#038;ssl=1\" alt=\"\" class=\"wp-image-1511\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=1024%2C269&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=300%2C79&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=768%2C202&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=700%2C184&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=520%2C136&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=360%2C94&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=250%2C66&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?resize=100%2C26&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac24.png?w=1227&amp;ssl=1 1227w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Lembra da <strong><span class=\"has-inline-color has-vivid-cyan-blue-color\">Op\u00e7\u00e3o2  <\/span><\/strong>para <strong>salvar o arquivo .bacpac<\/strong>? B\u00f4nus! \ud83d\ude09<\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Vamos fazer ela tamb\u00e9m para voc\u00ea escolher a melhor, conforme sua realidade.<\/span><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"423\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?resize=640%2C423&#038;ssl=1\" alt=\"\" class=\"wp-image-1548\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?w=736&amp;ssl=1 736w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?resize=300%2C198&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?resize=700%2C462&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?resize=520%2C343&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?resize=360%2C238&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?resize=250%2C165&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac58.png?resize=100%2C66&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Fa\u00e7a <strong>login <\/strong>na sua conta e escolha o <strong>Storage Account<\/strong> e o <strong>Blob Container<\/strong>, conforme criamos anteriormente.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"314\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?resize=640%2C314&#038;ssl=1\" alt=\"\" class=\"wp-image-1513\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?w=706&amp;ssl=1 706w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?resize=300%2C147&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?resize=700%2C343&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?resize=520%2C255&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?resize=360%2C176&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?resize=250%2C123&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac26.png?resize=100%2C49&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>D\u00ea um nome para seu arquivo .bacpac que ser\u00e1 exportado. <br>Veja que estou atribuindo um nome diferente do primeiro.<br><\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Temos uma novidade, sabe o que \u00e9 este Temporary file name?<\/span><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"581\" height=\"566\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac27.png?resize=581%2C566&#038;ssl=1\" alt=\"\" class=\"wp-image-1514\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac27.png?w=581&amp;ssl=1 581w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac27.png?resize=300%2C292&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac27.png?resize=520%2C507&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac27.png?resize=360%2C351&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac27.png?resize=250%2C244&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac27.png?resize=100%2C97&amp;ssl=1 100w\" sizes=\"(max-width: 581px) 100vw, 581px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>O <strong>Temporary File Name<\/strong> \u00e9 o local onde o arquivo tempor\u00e1rio do <strong>.bacpac<\/strong> ser\u00e1 criado.<\/p>\n\n\n\n<ul><li>Antes de enviar o arquivo diretamente para o <strong>Azure Blob Storage, o SQL Server Management Studio<\/strong> (SSMS) exporta o conte\u00fado do banco de dados para um arquivo tempor\u00e1rio no local especificado.<\/li><li>Este arquivo tempor\u00e1rio cont\u00e9m os <strong>dados <\/strong>e <strong>metadados <\/strong>do banco de dados.<\/li><\/ul>\n\n\n\n<p><strong>Upload para o Blob Storage:<\/strong><\/p>\n\n\n\n<p>Ap\u00f3s a cria\u00e7\u00e3o do arquivo tempor\u00e1rio, ele ser\u00e1 carregado no container do <strong>Azure Blob Storage<\/strong> especificado.<\/p>\n\n\n\n<p><strong>Remo\u00e7\u00e3o Autom\u00e1tica:<\/strong><\/p>\n\n\n\n<p>Depois que o upload para o Azure for conclu\u00eddo, o arquivo tempor\u00e1rio pode ser exclu\u00eddo automaticamente ou permanecer na pasta tempor\u00e1ria (dependendo do comportamento do SSMS).<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Importante:<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><strong>Espa\u00e7o em Disco:<\/strong> Certifique-se de que o local configurado para o arquivo tempor\u00e1rio tenha espa\u00e7o suficiente, especialmente para bancos de dados grandes.<\/p><p><strong>Permiss\u00f5es de Escrita:<\/strong> O caminho configurado deve ter permiss\u00f5es para grava\u00e7\u00e3o, caso contr\u00e1rio, o processo pode falhar.<\/p><p><strong>Posso alterar o caminho onde ser\u00e1 gravado temporariamente?<\/strong><\/p><p>Sim, voc\u00ea pode clicar no bot\u00e3o <strong>Browse<\/strong> e selecionar outro local no disco onde deseja que o arquivo tempor\u00e1rio seja criado. Isso \u00e9 \u00fatil para:<\/p><p>&#8211; Redirecionar para um disco com mais espa\u00e7o.<\/p><p>&#8211; Facilitar o acesso ao arquivo, caso precise analis\u00e1-lo antes do upload.<\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"519\" height=\"65\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac28.png?resize=519%2C65&#038;ssl=1\" alt=\"\" class=\"wp-image-1515\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac28.png?w=519&amp;ssl=1 519w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac28.png?resize=300%2C38&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac28.png?resize=360%2C45&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac28.png?resize=250%2C31&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac28.png?resize=100%2C13&amp;ssl=1 100w\" sizes=\"(max-width: 519px) 100vw, 519px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Curiosidade que voc\u00ea deve estar se perguntando, o tamanho salvo \u00e9 o mesmo? A resposta \u00e9 SIM!<\/span><\/strong><\/p>\n\n\n\n<p>Arquivo que salvamos anteriormente no disco local, na <span class=\"has-inline-color has-vivid-red-color\"><strong>op\u00e7\u00e3o1<\/strong><\/span>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-zoooom\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac30.png?resize=498%2C137&#038;ssl=1\" alt=\"\" class=\"wp-image-1517\" width=\"498\" height=\"137\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac30.png?w=421&amp;ssl=1 421w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac30.png?resize=300%2C83&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac30.png?resize=360%2C99&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac30.png?resize=250%2C69&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac30.png?resize=100%2C28&amp;ssl=1 100w\" sizes=\"(max-width: 498px) 100vw, 498px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Agora o arquivo tempor\u00e1rio, conforme passos da <strong><span class=\"has-inline-color has-vivid-cyan-blue-color\">op\u00e7\u00e3o2<\/span><\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-zoooom\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac31.png?resize=640%2C107&#038;ssl=1\" alt=\"\" class=\"wp-image-1518\" width=\"640\" height=\"107\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac31.png?w=604&amp;ssl=1 604w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac31.png?resize=300%2C50&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac31.png?resize=520%2C87&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac31.png?resize=360%2C60&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac31.png?resize=250%2C42&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac31.png?resize=100%2C17&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Infelizmente, pelas pesquisas que fiz, diziam que o arquivo tempor\u00e1rio \u00e9 <strong>obrigat\u00f3rio<\/strong> durante o processo de exporta\u00e7\u00e3o do banco de dados para um arquivo <strong>.bacpac<\/strong>. O SQL Server Management Studio (SSMS) <strong>sempre precisa<\/strong> criar esse arquivo tempor\u00e1rio, mesmo que o destino final seja o <strong>Azure Blob Storage<\/strong>.<\/p>\n\n\n\n<ul><li><strong>Valida\u00e7\u00e3o:<\/strong><ul><li>O arquivo tempor\u00e1rio permite que o SSMS valide os dados antes de transferi-los para o Azure, garantindo integridade e consist\u00eancia.<\/li><\/ul><\/li><li><strong>Proibi\u00e7\u00e3o de Ignorar o Campo:<\/strong><ul><li>Se voc\u00ea tentar deixar o campo vazio ou remov\u00ea-lo, o processo n\u00e3o continuar\u00e1 porque o SSMS n\u00e3o ter\u00e1 onde salvar temporariamente os dados do banco.<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><strong>Continuando nossos passos&#8230;<\/strong><\/p>\n\n\n\n<p>Pr\u00f3xima tela, confira se est\u00e3o tudo ok, e pronto.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"236\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?resize=640%2C236&#038;ssl=1\" alt=\"\" class=\"wp-image-1516\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?w=745&amp;ssl=1 745w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?resize=300%2C111&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?resize=700%2C258&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?resize=520%2C192&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?resize=360%2C133&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?resize=250%2C92&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac29.png?resize=100%2C37&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Conclu\u00eddo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"479\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?resize=640%2C479&#038;ssl=1\" alt=\"\" class=\"wp-image-1519\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?w=747&amp;ssl=1 747w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?resize=300%2C224&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?resize=700%2C524&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?resize=520%2C389&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?resize=360%2C269&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?resize=250%2C187&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac32.png?resize=100%2C75&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Upload conclu\u00eddo com sucesso. Ambos arquivos seguem no blob.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"206\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=640%2C206&#038;ssl=1\" alt=\"\" class=\"wp-image-1520\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?w=887&amp;ssl=1 887w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=300%2C96&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=768%2C247&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=700%2C225&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=520%2C167&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=360%2C116&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=250%2C80&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac33.png?resize=100%2C32&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>2.7 &#8211; Como importar o arquivo .bacpac para o Azure SQL Database<\/strong><\/p>\n\n\n\n<ul><li><strong>Acesse o Portal do Azure:<\/strong><\/li><\/ul>\n\n\n\n<p>Fa\u00e7a login no <a href=\"https:\/\/portal.azure.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Portal do Azure<\/a>.<\/p>\n\n\n\n<ul><li><strong>V\u00e1 para o Servidor SQL:<\/strong><\/li><\/ul>\n\n\n\n<p>No menu esquerdo, selecione <strong>Azure SQL<\/strong>.<\/p>\n\n\n\n<p>N\u00e3o temos nenhum criado, portanto vamos criar um novo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"327\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac34.png?resize=640%2C327&#038;ssl=1\" alt=\"\" class=\"wp-image-1521\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac34.png?w=646&amp;ssl=1 646w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac34.png?resize=300%2C153&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac34.png?resize=520%2C266&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac34.png?resize=360%2C184&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac34.png?resize=250%2C128&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac34.png?resize=100%2C51&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Criado o <strong>serverbacpac<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"208\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=640%2C208&#038;ssl=1\" alt=\"\" class=\"wp-image-1530\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?w=855&amp;ssl=1 855w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=300%2C98&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=768%2C250&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=700%2C228&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=520%2C169&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=360%2C117&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=250%2C81&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac43.png?resize=100%2C33&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Ap\u00f3s cria\u00e7\u00e3o, vamos copiar o nome do server, pois ser\u00e1 \u00fatil depois.<\/p>\n\n\n\n<p><strong>serverbacpac.database.windows.net<\/strong><\/p>\n\n\n\n<p>Faremos agora o &#8220;<strong>import database<\/strong>&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"185\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=640%2C185&#038;ssl=1\" alt=\"\" class=\"wp-image-1531\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=1024%2C296&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=300%2C87&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=768%2C222&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=700%2C203&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=520%2C151&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=360%2C104&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=250%2C72&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?resize=100%2C29&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac44.png?w=1057&amp;ssl=1 1057w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Vamos selecionar o <strong>arquivo de backup<\/strong>, ou seja, o .<strong>bacpac<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"290\" height=\"154\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac60.png?resize=290%2C154&#038;ssl=1\" alt=\"\" class=\"wp-image-1552\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac60.png?w=290&amp;ssl=1 290w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac60.png?resize=250%2C133&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac60.png?resize=100%2C53&amp;ssl=1 100w\" sizes=\"(max-width: 290px) 100vw, 290px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Nosso <strong>Storage account.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"202\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac46.png?resize=640%2C202&#038;ssl=1\" alt=\"\" class=\"wp-image-1533\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac46.png?w=698&amp;ssl=1 698w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac46.png?resize=300%2C95&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac46.png?resize=520%2C164&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac46.png?resize=360%2C113&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac46.png?resize=250%2C79&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac46.png?resize=100%2C32&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Nosso <strong>Container<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"184\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?resize=640%2C184&#038;ssl=1\" alt=\"\" class=\"wp-image-1534\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?w=760&amp;ssl=1 760w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?resize=300%2C86&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?resize=700%2C201&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?resize=520%2C149&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?resize=360%2C103&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?resize=250%2C72&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac47.png?resize=100%2C29&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Os dois arquivos .bacpac dispon\u00edveis.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"229\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=640%2C229&#038;ssl=1\" alt=\"\" class=\"wp-image-1535\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?w=1022&amp;ssl=1 1022w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=300%2C107&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=768%2C275&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=700%2C251&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=520%2C186&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=360%2C129&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=250%2C90&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac48.png?resize=100%2C36&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Optei pelo segundo, mas sem prefer\u00eancia.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"320\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=640%2C320&#038;ssl=1\" alt=\"\" class=\"wp-image-1536\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=1024%2C512&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=300%2C150&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=768%2C384&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=700%2C350&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=520%2C260&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=360%2C180&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=250%2C125&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?resize=100%2C50&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac49.png?w=1039&amp;ssl=1 1039w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Necess\u00e1rio escolher o Tier e preencher os demais campos conforme necessidade.<br>Escolhi o <strong>Basic Service Tier<\/strong> para esse lab, ele ser\u00e1 suficiente para importar a base e realizar valida\u00e7\u00f5es sem custos elevados.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"333\" height=\"538\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac50.png?resize=333%2C538&#038;ssl=1\" alt=\"\" class=\"wp-image-1537\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac50.png?w=333&amp;ssl=1 333w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac50.png?resize=186%2C300&amp;ssl=1 186w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac50.png?resize=250%2C404&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac50.png?resize=100%2C162&amp;ssl=1 100w\" sizes=\"(max-width: 333px) 100vw, 333px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Pronto, nosso import deu erro, e agora?<\/span><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"235\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=640%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-1538\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=1024%2C376&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=300%2C110&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=768%2C282&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=700%2C257&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=520%2C191&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=360%2C132&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=250%2C92&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?resize=100%2C37&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac51.png?w=1095&amp;ssl=1 1095w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>{&#8220;code&#8221;:&#8221;<em>ImportExportJobError&#8221;,&#8221;message&#8221;:&#8221;The ImportExport operation with Request Id &#8216;8936391a-e8ad-41a7-b8f4-ea286d9b7d55&#8217; failed due to &#8216;The ImportExport operation with Request Id &#8216;8936391a-e8ad-41a7-b8f4-ea286d9b7d55&#8217; failed due to &#8216;The SQL instance is inaccessible because the public network interface is denied (Error 47073). Please enable public network access on the SQL Server or configure Import\/Export to use Private Link as described in https:\/\/go.microsoft.com\/fwlink\/?linkid=2217536.&#8217;.&#8217;.&#8221;}<\/em><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>O erro indica que a opera\u00e7\u00e3o de importa\u00e7\u00e3o\/exporta\u00e7\u00e3o falhou porque o acesso p\u00fablico ao SQL Server est\u00e1 desativado. Isso acontece porque o servidor SQL est\u00e1 configurado para negar conex\u00f5es via rede p\u00fablica, impedindo o Azure de acessar o destino para a importa\u00e7\u00e3o.<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>No SQL server, basta localizar as configura\u00e7\u00f5es de <strong>Networking<\/strong>.<br>Por seguran\u00e7a, esta op\u00e7\u00e3o por default vem <strong>Disable<\/strong>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"279\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=640%2C279&#038;ssl=1\" alt=\"\" class=\"wp-image-1540\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?w=827&amp;ssl=1 827w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=300%2C131&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=768%2C335&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=700%2C306&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=520%2C227&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=360%2C157&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=250%2C109&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac52.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Vamos portanto habilitar.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"277\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=640%2C277&#038;ssl=1\" alt=\"\" class=\"wp-image-1541\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?w=840&amp;ssl=1 840w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=300%2C130&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=768%2C332&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=700%2C303&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=520%2C225&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=360%2C156&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=250%2C108&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac53.png?resize=100%2C43&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Executando novo import.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"280\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac61.png?resize=640%2C280&#038;ssl=1\" alt=\"\" class=\"wp-image-1553\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac61.png?w=652&amp;ssl=1 652w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac61.png?resize=300%2C131&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac61.png?resize=520%2C227&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac61.png?resize=360%2C157&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac61.png?resize=250%2C109&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac61.png?resize=100%2C44&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Nesta nova tentativa optei por colocar a base nova com name <strong>AdventureWork2024_new2<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"633\" height=\"211\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac54.png?resize=633%2C211&#038;ssl=1\" alt=\"\" class=\"wp-image-1542\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac54.png?w=633&amp;ssl=1 633w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac54.png?resize=300%2C100&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac54.png?resize=520%2C173&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac54.png?resize=360%2C120&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac54.png?resize=250%2C83&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac54.png?resize=100%2C33&amp;ssl=1 100w\" sizes=\"(max-width: 633px) 100vw, 633px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Hora da verdade! Vamos validar via SSMS.<\/span><\/strong><br> <br>Usaremos o <strong>nome do servidor<\/strong> conforme copiado anteriormente, juntamente com o <strong>login <\/strong>e <strong>password<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized is-style-zoooom\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac55.png?resize=508%2C334&#038;ssl=1\" alt=\"\" class=\"wp-image-1543\" width=\"508\" height=\"334\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac55.png?w=424&amp;ssl=1 424w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac55.png?resize=300%2C197&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac55.png?resize=360%2C237&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac55.png?resize=250%2C165&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac55.png?resize=100%2C66&amp;ssl=1 100w\" sizes=\"(max-width: 508px) 100vw, 508px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Base restaurada!<\/span><\/strong> \ud83d\ude09<\/p>\n\n\n\n<p>Servidor On-Premise x Azure SQL.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"251\" height=\"379\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac56.png?resize=251%2C379&#038;ssl=1\" alt=\"\" class=\"wp-image-1544\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac56.png?w=251&amp;ssl=1 251w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac56.png?resize=199%2C300&amp;ssl=1 199w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac56.png?resize=250%2C377&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac56.png?resize=100%2C151&amp;ssl=1 100w\" sizes=\"(max-width: 251px) 100vw, 251px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Comparativo b\u00e1sico.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"374\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=640%2C374&#038;ssl=1\" alt=\"\" class=\"wp-image-1545\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?w=934&amp;ssl=1 934w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=300%2C175&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=768%2C449&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=700%2C409&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=520%2C304&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=360%2C210&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=250%2C146&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac57.png?resize=100%2C58&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Conforme citado no in\u00edcio do post, no Azure SQL alguns conceitos s\u00e3o diferentes e alguns n\u00e3o suportados. Necess\u00e1rio fazer esta an\u00e1lise antes de realizar a migra\u00e7\u00e3o.<br><\/p>\n\n\n\n<p><strong>Exemplo:<\/strong><\/p>\n\n\n\n<ul><li>No Azure SQL, o conceito de <strong>logins <\/strong>no n\u00edvel de servidor \u00e9 substitu\u00eddo por usu\u00e1rios dentro do banco de dados.<\/li><\/ul>\n\n\n\n<ul><li>Use uma ferramenta alternativa para <strong>automa\u00e7\u00e3o<\/strong>, como Azure Logic Apps, Azure Automation, ou Elastic Jobs para criar jobs equivalentes.<\/li><\/ul>\n\n\n\n<ul><li><strong>Linked Servers<\/strong>, n\u00e3o s\u00e3o suportados no Azure SQL Database.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3><strong>Conclus\u00e3o<\/strong><\/h3>\n\n\n\n<p>A migra\u00e7\u00e3o utilizando <strong>Backup BACPAC<\/strong> \u00e9 um m\u00e9todo eficiente para transferir bancos de dados SQL Server para o <strong>Azure SQL Database<\/strong>. Por\u00e9m, assim como os demais m\u00e9todos, precisa ser analisado e planejado com anteced\u00eancia. Para comprovar se este m\u00e9todo realmente vai atender conforme necessidade e regra de neg\u00f3cio.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Ufa, encerramos este POST, espero que tenha contribu\u00eddo alguma coisa para o seu aprendizado.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Lembrando que darei continuidade nesta \u201cs\u00e9rie\u201d.<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">Aguardem\u2026<\/span><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" width=\"464\" height=\"122\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac62.png?resize=464%2C122&#038;ssl=1\" alt=\"\" class=\"wp-image-1554\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac62.png?w=464&amp;ssl=1 464w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac62.png?resize=300%2C79&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac62.png?resize=360%2C95&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac62.png?resize=250%2C66&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/bac62.png?resize=100%2C26&amp;ssl=1 100w\" sizes=\"(max-width: 464px) 100vw, 464px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Obrigado, e quaisquer d\u00favidas, sugest\u00f5es, elogios e reclama\u00e7\u00f5es, \u2026 podem me enviar! \ud83d\ude09<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Seguem alguns links como refer\u00eancias usadas para escrever este post.<\/p>\n\n\n\n<ul><li><a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/pt-br\/azure\/migrate\/migrate-services-overview\" target=\"_blank\">Microsoft Azure Migration Overview<\/a><\/li><\/ul>\n\n\n\n<ul><li><a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/sql-database\/sql-database-import\" target=\"_blank\">Microsoft Docs &#8211; Export and Import BACPAC<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>&#8230;Dando continuidade \u00e0 nossa s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise.<br \/>\nSe voc\u00ea ainda n\u00e3o leu o primeiro post da s\u00e9rie, d\u00ea uma olhada, ficou bem completo. Usei o m\u00e9todo \u201cDeploy Database to Microsoft Azure SQL Database\u201d, detalhando cada passo.<\/p>\n<p>1) Deploy Database to Microsoft Azure SQL Database (link do post)<\/p>\n<p>Hoje, nesta Parte 2, abordaremos o m\u00e9todo de migra\u00e7\u00e3o que utiliza o Backup BACPAC e Importa\u00e7\u00e3o. Este m\u00e9todo \u00e9 bastante utilizado, para transferir bancos de dados SQL Server para o Azure SQL Database.<\/p>\n<p>2) Backup bacpac com import<br \/>\nTamb\u00e9m conhecido como \u201cexport x import\u201d, pois envolve exportar o banco como um arquivo .bacpac , em seguida import\u00e1-lo no Azure SQL Database.<\/p>\n<p>O formato BACPAC \u00e9 um arquivo que cont\u00e9m o esquema do banco de dados e seus dados, permitindo uma migra\u00e7\u00e3o \u201cf\u00e1cil\u201d e eficiente.<\/p>\n<p>Vantagens:<br \/>\nPortabilidade: O arquivo .bacpac \u00e9 port\u00e1til, podendo ser movido facilmente entre diferentes servidores, ambientes ou at\u00e9 mesmo armazenado como backup.<br \/>\nControle de Tamanho e Escopo: Ele cont\u00e9m apenas o esquema e os dados (sem objetos de sistema), o que reduz o tamanho e simplifica a migra\u00e7\u00e3o.<br \/>\nSuporte Amplamente Dispon\u00edvel: O m\u00e9todo \u00e9 suportado por ferramentas como SSMS e o Portal do Azure, proporcionando flexibilidade.<\/p>\n<p>Desvantagens:<br \/>\nLimita\u00e7\u00f5es de Dados: Dados corrompidos, muito grandes ou incompat\u00edveis podem causar falhas durante a exporta\u00e7\u00e3o e\/ou importa\u00e7\u00e3o.<br \/>\nTempo de Processamento: Pode levar tempo para criar e importar o .bacpac, dependendo do tamanho do banco de dados.<br \/>\nN\u00e3o Suporta Algumas Configura\u00e7\u00f5es Avan\u00e7adas: Configura\u00e7\u00f5es espec\u00edficas do servidor, como permiss\u00f5es de login, n\u00e3o s\u00e3o inclu\u00eddas no arquivo .bacpac.<\/p>\n","protected":false},"author":1,"featured_media":1560,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"spay_email":""},"categories":[1],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/banner.png?fit=474%2C422&ssl=1","jetpack-related-posts":[{"id":1406,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte1\/","url_meta":{"origin":1484,"position":0},"title":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE1)","date":"janeiro 20, 2025","format":false,"excerpt":"\u2026 vou seguir com meus objetivos e iniciar uma \u201cs\u00e9rie\u201d de post cujo assunto ser\u00e1 \u201cMigra\u00e7\u00e3o On-Premise para Azure SQL\u201d Portanto darei o nome deste de hoje como \u2026PARTE1. Para migrar um database do On-Premise para o Azure SQL temos v\u00e1rias op\u00e7\u00f5es. Cada op\u00e7\u00e3o tem suas vantagens e desvantagens espec\u00edficas.\u2026","rel":"","context":"Com 1 coment\u00e1rio","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/banner.png?fit=616%2C520&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1580,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-de-banco-de-dados-on-premise-para-azure-sql-parte3\/","url_meta":{"origin":1484,"position":1},"title":"Migra\u00e7\u00e3o de Banco de Dados On-Premise para Azure SQL (PARTE3)","date":"fevereiro 26, 2025","format":false,"excerpt":"\u2026Dando continuidade \u00e0 nossa s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise. Se voc\u00ea ainda n\u00e3o leu os posts anteriores, d\u00ea uma olhada. 1) Deploy Database to Microsoft Azure SQL Database. 2) Backup bacpac com import Agora, na Parte 3, vamos explorar a migra\u00e7\u00e3o usando o DMA. 3. DMA (Data\u2026","rel":"","context":"Post similar","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/dma.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":339,"url":"https:\/\/ederlelis.com.br\/blog\/restore-database-azure-usando-ssms\/","url_meta":{"origin":1484,"position":2},"title":"Restore de Backups Armazenados no Azure usando Microsoft SSMS","date":"abril 10, 2022","format":false,"excerpt":"Neste primeiro Post do meu blog abordarei um assunto que a cada dia que passa, quanto mais aprendo, mais quero aprender, SQL x Azure. Vamos fazer um Restore de Backups armazenados no Blob do Azure usando o Microsoft SQL Server Management Studio (SSMS).","rel":"","context":"Em \"Azure\"","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/03\/00.png?fit=447%2C222&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":538,"url":"https:\/\/ederlelis.com.br\/blog\/automatizar_backups_armazenando_em_blob_no_azure\/","url_meta":{"origin":1484,"position":3},"title":"Automatizar Backups Armazenando em Blob &#8211; Azure usando Microsoft SSMS","date":"maio 28, 2022","format":false,"excerpt":"Para aqueles que querem criar um Job de Backup e automatizar o trabalho pensando principalmente em seguran\u00e7a, afinal, se um dia algo acontecer com meu banco de dados, ser\u00e1 que est\u00e1 preparado? Quanto \"tempo de dados\" posso perder? 1) Automatiza\u00e7\u00e3o de backup Para criarmos um job de backup vou usar\u2026","rel":"","context":"Em &quot;MSSQL&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/05\/topo_bkp_aut3.png?fit=407%2C316&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":424,"url":"https:\/\/ederlelis.com.br\/blog\/criptografia-dados-transparente-tde-criptografar-database-mssql\/","url_meta":{"origin":1484,"position":4},"title":"Criptografia  Dados Transparente &#8211; TDE: Como Criptografar sua Database MSSQL?","date":"abril 9, 2022","format":false,"excerpt":"Neste post vou falar de uma demanda que est\u00e1 aumentando muito atualmente, devido a LGPD. Portanto, com base nesse processo de gest\u00e3o e governan\u00e7a de dados, um grande aliado \u201cagregado\u201d ao SQL Server \u00e9 o TDE (Transparent Data Encryption). A criptografia de dados transparente criptografa os arquivos de dados (mdf)\u2026","rel":"","context":"Em &quot;MSSQL&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/04\/cadeado.jpeg?fit=595%2C501&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":692,"url":"https:\/\/ederlelis.com.br\/blog\/configurar-database-mail-no-sql-server-utilizando-uma-conta-do-gmail\/","url_meta":{"origin":1484,"position":5},"title":"Configurar Database-mail no SQL Server utilizando uma conta do Gmail.","date":"setembro 5, 2022","format":false,"excerpt":"Bora pra mais um assunto do meu dia a dia, apesar de \"simples\" para alguns, por\u00e9m ainda d\u00e1 trabalho e dor de cabe\u00e7a para muitos, rsrs. Vamos l\u00e1! Neste post voc\u00ea vai aprender na pr\u00e1tica a configurar o Database mail no SQL Server e tamb\u00e9m a configurar uma senha espec\u00edfica\u2026","rel":"","context":"Em &quot;Database mail&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2022\/09\/database_mail.jpg.png?fit=872%2C489&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/1484"}],"collection":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/comments?post=1484"}],"version-history":[{"count":12,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/1484\/revisions"}],"predecessor-version":[{"id":1559,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/1484\/revisions\/1559"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media\/1560"}],"wp:attachment":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}