{"id":1406,"date":"2025-01-20T00:09:31","date_gmt":"2025-01-20T03:09:31","guid":{"rendered":"https:\/\/ederlelis.com.br\/blog\/?p=1406"},"modified":"2025-01-20T00:09:45","modified_gmt":"2025-01-20T03:09:45","slug":"migracao-on-premise-para-azure-sql-parte1","status":"publish","type":"post","link":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte1\/","title":{"rendered":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE1)"},"content":{"rendered":"\n<p>Ol\u00e1, espero que voc\u00ea esteja bem!&nbsp;\ud83d\ude09<\/p>\n\n\n\n<p>Conforme planejamento e <strong>metas tra\u00e7adas para 2025<\/strong> \u2026<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><em>Quem ainda n\u00e3o viu meu post de retrospectiva com algumas metas, segue link, confira!<\/em> <a rel=\"noreferrer noopener\" href=\"https:\/\/ederlelis.com.br\/blog\/retrospectiva-ano-2024\/\" target=\"_blank\">https:\/\/ederlelis.com.br\/blog\/retrospectiva-ano-2024\/<\/a><\/p><\/blockquote>\n\n\n\n<p>\u2026 vou seguir com meus objetivos e iniciar uma &#8220;s\u00e9rie&#8221; de post cujo assunto ser\u00e1 \u201c<strong>Migra\u00e7\u00e3o On-Premise para Azure SQL<\/strong>\u201d Portanto darei o nome deste de hoje como &#8230;PARTE1. <\/p>\n\n\n\n<p>Para migrar um database do On-Premise para o Azure SQL temos v\u00e1rias op\u00e7\u00f5es.<\/p>\n\n\n\n<p><strong>Cada op\u00e7\u00e3o tem suas vantagens e desvantagens espec\u00edficas<\/strong>. Dependendo por exemplo do tamanho das databases, da complexidade do ambiente, do tempo aceit\u00e1vel de inatividade durante processo de migra\u00e7\u00e3o, dentre outros fatores.<\/p>\n\n\n\n<p>A princ\u00edpio escolhi tr\u00eas maneiras bastantes utilizadas para realizar a migra\u00e7\u00e3o de bases, e por isso vou dividir em 3 partes (tr\u00eas Post) para n\u00e3o ficar cansativo.<\/p>\n\n\n\n<p>S\u00e3o elas:<\/p>\n\n\n\n<ul><li><strong>Deploy Database to Microsoft Azure SQL Database<\/strong><\/li><li><strong>Backup bac com import<\/strong><\/li><li><strong>DMA<\/strong><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><span class=\"has-inline-color has-luminous-vivid-orange-color\"><strong>Bora come\u00e7ar?!<\/strong><\/span><\/p>\n\n\n\n<p>Iniciando a s\u00e9rie sobre Migra\u00e7\u00e3o On-Premise para Azure SQL, abordo hoje o m\u00e9todo &#8216;Deploy Database to Microsoft Azure SQL Database&#8217;. Vamos explorar as vantagens, desafios e um passo a passo detalhado para facilitar sua jornada para a nuvem.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ol><li><strong>Deploy Database to Microsoft Azure SQL Database<\/strong>:<\/li><\/ol>\n\n\n\n<p>Uma op\u00e7\u00e3o \u201cdireta\u201d do SQL Server Management Studio (SSMS) para migrar bancos para o Azure SQL Database.<\/p>\n\n\n\n<p><strong>Vantagens:<\/strong><\/p>\n\n\n\n<ul><li><strong>Simplicidade<\/strong>: O processo \u00e9 integrado ao SSMS, facilitando a migra\u00e7\u00e3o, sem a necessidade de ferramentas adicionais.<\/li><li><strong>Familiaridade<\/strong>: Administradores de banco de dados que j\u00e1 utilizam o SSMS encontrar\u00e3o familiaridade no processo, reduzindo a curva de aprendizado.<\/li><\/ul>\n\n\n\n<p><strong>Desvantagens:<\/strong><\/p>\n\n\n\n<ul><li><strong>Limita\u00e7\u00f5es de Tamanho<\/strong>: Bancos de dados muito grandes podem enfrentar dificuldades ou demorar mais tempo para serem migrados por esse m\u00e9todo.<\/li><li><strong>Downtime<\/strong>: Durante a migra\u00e7\u00e3o, o banco de dados pode ficar indispon\u00edvel, o que pode n\u00e3o ser ideal para ambientes que exigem alta disponibilidade.<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>1.1 &#8211; Prepara\u00e7\u00e3o do Ambiente<\/strong>:<\/p>\n\n\n\n<ul><li><strong>Backup<\/strong>: Por seguran\u00e7a, \u00e9 bom sempre ter um backup atualizado antes de iniciar qualquer processo.<\/li><li><strong>Compatibilidade<\/strong>: Certifique-se de que o banco de dados de origem \u00e9 compat\u00edvel com o Azure SQL Database, incluindo o suporte \u00e0s features utilizadas.<\/li><\/ul>\n\n\n\n<p>Para validar a compatibilidade da database, usaremos o <strong>DMA (Data Migration Assistant)<\/strong>, uma <strong>f<\/strong>erramenta da Microsoft, que tamb\u00e9m \u00e9 usada para realizar migra\u00e7\u00f5es. \ud83d\ude09 <span class=\"has-inline-color has-luminous-vivid-orange-color\"><strong>(assunto do post &#8230;PARTE3) <\/strong><\/span><strong><span class=\"has-inline-color has-black-color\">#spoiler<\/span><\/strong><\/p>\n\n\n\n<p><strong>Instala\u00e7\u00e3o do DMA:<\/strong><\/p>\n\n\n\n<ul><li>Baixe o <strong>Data Migration Assistant<\/strong> <a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/dma\/dma-overview\" target=\"_blank\">aqui<\/a>.<\/li><li>Instale a ferramenta em um computador com acesso ao servidor de origem.<\/li><li>Abra o DMA e clique em <strong>+ New Project<\/strong>.<\/li><li>Nomeie o projeto e selecione o tipo de migra\u00e7\u00e3o:<ul><li><strong>Assessment<\/strong>: Para avaliar a compatibilidade.<\/li><li>Migration: Para realizar migra\u00e7\u00e3o.<\/li><\/ul><\/li><li>Escolha o tipo de servidor de origem (<strong>SQL Server<\/strong>) e o destino (<strong>Azure SQL Database<\/strong>).<\/li><\/ul>\n\n\n\n<p><strong>Faremos portanto uma avalia\u00e7\u00e3o (assesment) de compatibilidade<\/strong>.<\/p>\n\n\n\n<p>Daremos o nome <strong>MigracaoDeploy<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"352\" height=\"535\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma1-1.png?resize=352%2C535&#038;ssl=1\" alt=\"\" class=\"wp-image-1421\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma1-1.png?w=352&amp;ssl=1 352w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma1-1.png?resize=197%2C300&amp;ssl=1 197w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma1-1.png?resize=250%2C380&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma1-1.png?resize=100%2C152&amp;ssl=1 100w\" sizes=\"(max-width: 352px) 100vw, 352px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"187\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=640%2C187&#038;ssl=1\" alt=\"\" class=\"wp-image-1422\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=1024%2C299&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=300%2C88&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=768%2C224&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=700%2C204&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=520%2C152&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=360%2C105&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=250%2C73&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?resize=100%2C29&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma2-1.png?w=1048&amp;ssl=1 1048w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Realizar uma Avalia\u00e7\u00e3o (Assessment):<\/strong><\/p>\n\n\n\n<ul><li>Conecte-se ao servidor de origem.<\/li><\/ul>\n\n\n\n<p>Como instalei o DMA no pr\u00f3prio servidor de origem, por isso basta colocar o nome como <strong>localhost<\/strong>, e o type usaremos o <strong>Windows Authentication<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"298\" height=\"393\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma3.png?resize=298%2C393&#038;ssl=1\" alt=\"\" class=\"wp-image-1423\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma3.png?w=298&amp;ssl=1 298w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma3.png?resize=227%2C300&amp;ssl=1 227w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma3.png?resize=250%2C330&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma3.png?resize=100%2C132&amp;ssl=1 100w\" sizes=\"(max-width: 298px) 100vw, 298px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Ap\u00f3s conectar, selecione os bancos de dados a serem analisados.<\/p>\n\n\n\n<p>No nosso caso <strong>vamos migrar a base chamada \u201cAdventureWorks2012\u201d<\/strong>.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><em>Inclusive segue link de reposit\u00f3rio AdventureWork, caso voc\u00ea precise para estudos e Labs.<\/em><\/p><p><em><a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/pt-br\/sql\/samples\/adventureworks-install-configure?view=sql-server-ver16&amp;tabs=ssms\" target=\"_blank\">Bancos de dados de exemplo do AdventureWorks &#8211; SQL Server | Microsoft Learn<\/a><\/em><\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"311\" height=\"153\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma5-1.png?resize=311%2C153&#038;ssl=1\" alt=\"\" class=\"wp-image-1424\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma5-1.png?w=311&amp;ssl=1 311w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma5-1.png?resize=300%2C148&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma5-1.png?resize=250%2C123&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma5-1.png?resize=100%2C49&amp;ssl=1 100w\" sizes=\"(max-width: 311px) 100vw, 311px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Ap\u00f3s a base ser inserida, basta clicar em <strong>Start Assessment<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"334\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=640%2C334&#038;ssl=1\" alt=\"\" class=\"wp-image-1425\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=1024%2C534&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=300%2C157&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=768%2C401&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=700%2C365&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=520%2C271&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=360%2C188&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=250%2C130&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?resize=100%2C52&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?w=1420&amp;ssl=1 1420w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma6-1.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>O DMA identificar\u00e1 a incompatibilidade, caso tenha. <\/p>\n\n\n\n<p>Podemos tamb\u00e9m exportar o relat\u00f3rio final.<\/p>\n\n\n\n<p><strong>Exemplo<\/strong>:<\/p>\n\n\n\n<p>Vejam que nossa base n\u00e3o possui nenhuma incompatibilidade, conforme vers\u00e3o a ser migrada.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"238\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=640%2C238&#038;ssl=1\" alt=\"\" class=\"wp-image-1426\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=1024%2C381&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=300%2C112&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=768%2C286&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=700%2C261&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=520%2C194&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=360%2C134&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=250%2C93&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?resize=100%2C37&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?w=1423&amp;ssl=1 1423w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma7-1.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<ul><li>Compatibilidade OK<\/li><\/ul>\n\n\n\n<p>Podemos salvar o projeto para futura verifica\u00e7\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"432\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=640%2C432&#038;ssl=1\" alt=\"\" class=\"wp-image-1427\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?w=909&amp;ssl=1 909w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=300%2C203&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=768%2C519&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=700%2C473&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=520%2C351&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=360%2C243&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=250%2C169&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/dma8.png?resize=100%2C68&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>1.2 &#8211; Configura\u00e7\u00e3o no Azure<\/strong>:<\/p>\n\n\n\n<p>No portal do Azure, vamos configurar um novo \u201c<strong>SQL Server<\/strong>\u201d e um <strong>\u201cBanco de Dados\u201d<\/strong>.<\/p>\n\n\n\n<p>Create <strong>SQL Server<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"299\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=640%2C299&#038;ssl=1\" alt=\"\" class=\"wp-image-1429\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=1024%2C478&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=300%2C140&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=768%2C358&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=700%2C326&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=520%2C243&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=360%2C168&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=250%2C117&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?resize=100%2C47&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver1.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Create <strong>SQL Database Server<\/strong><\/p>\n\n\n\n<p>Muita aten\u00e7\u00e3o neste momento, ap\u00f3s escolher a sua <strong>Subscription<\/strong>, <strong>Resource group<\/strong> (vamos criar um novo), ser\u00e1 necess\u00e1rio definir um <strong>Server name<\/strong>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"778\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=640%2C778&#038;ssl=1\" alt=\"\" class=\"wp-image-1430\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?w=776&amp;ssl=1 776w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=247%2C300&amp;ssl=1 247w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=768%2C933&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=700%2C851&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=520%2C632&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=360%2C437&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=250%2C304&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver2.png?resize=100%2C122&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Necess\u00e1rio definir tamb\u00e9m o <strong>Authentication method<\/strong>, criar um <strong>admin login<\/strong>, e um <strong>Password<\/strong>.<\/p>\n\n\n\n<p><span class=\"has-inline-color has-vivid-red-color\"><strong>*n\u00e3o esque\u00e7a de anotar o nome do server, login e senha, pois vamos precisar adiante.<\/strong><\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"416\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?resize=640%2C416&#038;ssl=1\" alt=\"\" class=\"wp-image-1432\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?w=710&amp;ssl=1 710w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?resize=300%2C195&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?resize=700%2C455&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?resize=520%2C338&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?resize=360%2C234&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?resize=250%2C162&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver3.png?resize=100%2C65&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Vamos conferir se est\u00e1 tudo correto?<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"476\" height=\"913\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver4-1.png?resize=476%2C913&#038;ssl=1\" alt=\"\" class=\"wp-image-1435\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver4-1.png?w=476&amp;ssl=1 476w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver4-1.png?resize=156%2C300&amp;ssl=1 156w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver4-1.png?resize=360%2C691&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver4-1.png?resize=250%2C480&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver4-1.png?resize=100%2C192&amp;ssl=1 100w\" sizes=\"(max-width: 476px) 100vw, 476px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Ap\u00f3s clicar em <strong>Create<\/strong>, basta esperar o <strong>Deployment<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"264\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=640%2C264&#038;ssl=1\" alt=\"\" class=\"wp-image-1436\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=1024%2C422&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=300%2C123&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=768%2C316&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=700%2C288&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=520%2C214&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=360%2C148&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=250%2C103&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?resize=100%2C41&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/sqlserver5.png?w=1030&amp;ssl=1 1030w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Terminado, anotaremos o <strong>Server name<\/strong>. <\/p>\n\n\n\n<p><span class=\"has-inline-color has-luminous-vivid-orange-color\">migracaoadm.database.windows.net<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"148\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=640%2C148&#038;ssl=1\" alt=\"\" class=\"wp-image-1439\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=1024%2C237&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=300%2C69&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=768%2C177&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=700%2C162&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=520%2C120&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=360%2C83&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=250%2C58&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?resize=100%2C23&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms15.png?w=1268&amp;ssl=1 1268w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>1.3 &#8211; Firewall <\/strong><\/p>\n\n\n\n<p>Por seguran\u00e7a, uma boa pr\u00e1tica \u00e9 ajustar o firewall para aceitar apenas o IP espec\u00edfico, evitando assim um acesso n\u00e3o autorizado.<\/p>\n\n\n\n<p>Apesar do meu IP ser identificado automaticamente, <strong>vamos colocar no firewall um IP errado<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"161\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=640%2C161&#038;ssl=1\" alt=\"\" class=\"wp-image-1438\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?w=825&amp;ssl=1 825w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=300%2C76&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=768%2C194&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=700%2C176&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=520%2C131&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=360%2C91&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=250%2C63&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms13-1.png?resize=100%2C25&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Que tal fazer um teste de conex\u00e3o?!<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"498\" height=\"469\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms14.png?resize=498%2C469&#038;ssl=1\" alt=\"\" class=\"wp-image-1440\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms14.png?w=498&amp;ssl=1 498w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms14.png?resize=300%2C283&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms14.png?resize=360%2C339&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms14.png?resize=250%2C235&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms14.png?resize=100%2C94&amp;ssl=1 100w\" sizes=\"(max-width: 498px) 100vw, 498px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Perfeito, conex\u00e3o n\u00e3o foi poss\u00edvel por falta de permiss\u00e3o<\/strong>. \ud83d\ude09<\/p>\n\n\n\n<p>Ajustaremos o firewall como o IP correto.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"494\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=640%2C494&#038;ssl=1\" alt=\"\" class=\"wp-image-1441\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=1024%2C791&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=300%2C232&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=768%2C594&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=700%2C541&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=520%2C402&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=360%2C278&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=250%2C193&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?resize=100%2C77&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/firewall1.png?w=1167&amp;ssl=1 1167w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Seguiremos com nossa migra\u00e7\u00e3o.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>1.4 &#8211; Migra\u00e7\u00e3o via SSMS<\/strong>:<\/p>\n\n\n\n<ul><li><strong>Conecte-se ao Banco de Dados de Origem<\/strong>: Abra o SSMS e conecte-se ao servidor On-premises.<\/li><li><strong>Inicie o Assistente de Implanta\u00e7\u00e3o<\/strong>:<ul><li>Clique com o bot\u00e3o direito no banco de dados que deseja migrar.<\/li><li>Selecione <strong>Tarefas<\/strong> > <strong>Deploy Database to Microsoft Azure SQL Database<\/strong>.<\/li><\/ul><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"506\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?resize=640%2C506&#038;ssl=1\" alt=\"\" class=\"wp-image-1442\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?w=751&amp;ssl=1 751w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?resize=300%2C237&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?resize=700%2C554&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?resize=520%2C411&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?resize=360%2C285&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?resize=250%2C198&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms1.png?resize=100%2C79&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\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\/01\/ssms2.png?resize=640%2C579&#038;ssl=1\" alt=\"\" class=\"wp-image-1444\" width=\"640\" height=\"579\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?w=818&amp;ssl=1 818w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?resize=300%2C271&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?resize=768%2C695&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?resize=700%2C633&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?resize=520%2C470&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?resize=360%2C326&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?resize=250%2C226&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms2.png?resize=100%2C90&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Nesse momento teremos que conectar no Server de destino, ou seja, no Azure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"209\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=640%2C209&#038;ssl=1\" alt=\"\" class=\"wp-image-1445\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?w=816&amp;ssl=1 816w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=300%2C98&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=768%2C251&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=700%2C229&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=520%2C170&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=360%2C118&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=250%2C82&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms3.1.png?resize=100%2C33&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Usaremos aquelas informa\u00e7\u00f5es que anotamos<\/strong> conforme comentei acima.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"473\" height=\"337\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.png?resize=473%2C337&#038;ssl=1\" alt=\"\" class=\"wp-image-1446\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.png?w=473&amp;ssl=1 473w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.png?resize=300%2C214&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.png?resize=360%2C256&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.png?resize=250%2C178&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.png?resize=100%2C71&amp;ssl=1 100w\" sizes=\"(max-width: 473px) 100vw, 473px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Neste momento, caso o firewall n\u00e3o estivesse com o IP liberado, iria dar erro na conex\u00e3o.<\/strong><\/p>\n\n\n\n<p>Conex\u00e3o OK<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul><li><strong>Configura\u00e7\u00f5es Adicionais<\/strong><\/li><\/ul>\n\n\n\n<p>Definir o <strong>database name<\/strong>, qual a <strong>edition <\/strong>Azure SQL Database e maximum database <strong>size<\/strong>.<\/p>\n\n\n\n<p>Ajustar conforme necessidade, pois s\u00e3o configura\u00e7\u00f5es de extrema import\u00e2ncia, podendo influenciar no tempo total de migra\u00e7\u00e3o e performance.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"340\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=640%2C340&#038;ssl=1\" alt=\"\" class=\"wp-image-1447\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?w=937&amp;ssl=1 937w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=300%2C159&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=768%2C408&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=700%2C372&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=520%2C276&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=360%2C191&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=250%2C133&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms4.1.png?resize=100%2C53&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>O <strong>Maximum database size <\/strong>\u00e9 diretamente relacionado ao tipo de <strong>edi\u00e7\u00e3o <\/strong>escolhido. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"487\" height=\"135\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms5.png?resize=487%2C135&#038;ssl=1\" alt=\"\" class=\"wp-image-1448\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms5.png?w=487&amp;ssl=1 487w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms5.png?resize=300%2C83&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms5.png?resize=360%2C100&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms5.png?resize=250%2C69&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms5.png?resize=100%2C28&amp;ssl=1 100w\" sizes=\"(max-width: 487px) 100vw, 487px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p> Confira o resumo das configura\u00e7\u00f5es escolhidas para iniciar a migra\u00e7\u00e3o propriamente dita.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"386\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=640%2C386&#038;ssl=1\" alt=\"\" class=\"wp-image-1450\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?w=810&amp;ssl=1 810w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=300%2C181&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=768%2C464&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=700%2C423&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=520%2C314&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=360%2C217&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=250%2C151&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms6.png?resize=100%2C60&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Em progresso&#8230;<\/strong><\/p>\n\n\n\n<p>Nesse ponto, assim como comentado no in\u00edcio do post&#8230;<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><span style=\"font-size: revert; color: initial;\">Bancos de dados muito grandes podem enfrentar dificuldades ou <strong>demorar mais tempo para serem migrado<\/strong>s por esse m\u00e9todo.<\/span><\/p><\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"584\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=640%2C584&#038;ssl=1\" alt=\"\" class=\"wp-image-1451\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?w=809&amp;ssl=1 809w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=300%2C274&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=768%2C701&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=700%2C639&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=520%2C474&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=360%2C328&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=250%2C228&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms8.png?resize=100%2C91&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Processo finalizado.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"585\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=640%2C585&#038;ssl=1\" alt=\"\" class=\"wp-image-1452\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?w=806&amp;ssl=1 806w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=300%2C274&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=768%2C702&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=700%2C640&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=520%2C475&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=360%2C329&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=250%2C229&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms10.png?resize=100%2C91&amp;ssl=1 100w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>1.5 &#8211; P\u00f3s-Migra\u00e7\u00e3o<\/strong>:<\/p>\n\n\n\n<ul><li><strong>Verifica\u00e7\u00e3o<\/strong>: Ap\u00f3s a conclus\u00e3o, conecte-se ao banco de dados no Azure e verifique se todos os dados e objetos foram migrados corretamente.<\/li><li><strong>Ajustes Necess\u00e1rios<\/strong>: Atualize strings de conex\u00e3o em aplicativos e realize testes para garantir que tudo funcione como esperado.<\/li><\/ul>\n\n\n\n<p><strong>Ao finalizar por completo, a base esta<\/strong>r\u00e1 ONLINE com as tabelas povoadas.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Podemos tamb\u00e9m conferir via SSMS.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"344\" height=\"434\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/migracaoadm1.png?resize=344%2C434&#038;ssl=1\" alt=\"\" class=\"wp-image-1454\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/migracaoadm1.png?w=344&amp;ssl=1 344w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/migracaoadm1.png?resize=238%2C300&amp;ssl=1 238w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/migracaoadm1.png?resize=250%2C315&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/migracaoadm1.png?resize=100%2C126&amp;ssl=1 100w\" sizes=\"(max-width: 344px) 100vw, 344px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p><strong>Database On-Premises e Azure SQL Database.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"270\" height=\"344\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms12.png?resize=270%2C344&#038;ssl=1\" alt=\"\" class=\"wp-image-1453\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms12.png?w=270&amp;ssl=1 270w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms12.png?resize=235%2C300&amp;ssl=1 235w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms12.png?resize=250%2C319&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms12.png?resize=100%2C127&amp;ssl=1 100w\" sizes=\"(max-width: 270px) 100vw, 270px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Usaremos um SELECT simples para comparar os resultados.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-zoooom\"><img loading=\"lazy\" width=\"640\" height=\"216\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=640%2C216&#038;ssl=1\" alt=\"\" class=\"wp-image-1455\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=1024%2C345&amp;ssl=1 1024w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=300%2C101&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=768%2C259&amp;ssl=1 768w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=700%2C236&amp;ssl=1 700w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=520%2C175&amp;ssl=1 520w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=360%2C121&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=250%2C84&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?resize=100%2C34&amp;ssl=1 100w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?w=1494&amp;ssl=1 1494w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/ssms11.png?w=1280&amp;ssl=1 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Encerramos portanto este POST, espero que tenha contribu\u00eddo alguma coisa para o seu aprendizado.<\/p>\n\n\n\n<p><strong>Lembrando que darei continuidade nesta &#8220;s\u00e9rie&#8221;.<\/strong><\/p>\n\n\n\n<p><span class=\"has-inline-color has-luminous-vivid-orange-color\"><strong>Aguardem&#8230;<\/strong><\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-zoooom\"><img loading=\"lazy\" width=\"453\" height=\"72\" src=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/fim.png?resize=453%2C72&#038;ssl=1\" alt=\"\" class=\"wp-image-1458\" srcset=\"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/fim.png?w=453&amp;ssl=1 453w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/fim.png?resize=300%2C48&amp;ssl=1 300w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/fim.png?resize=360%2C57&amp;ssl=1 360w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/fim.png?resize=250%2C40&amp;ssl=1 250w, https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/fim.png?resize=100%2C16&amp;ssl=1 100w\" sizes=\"(max-width: 453px) 100vw, 453px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Obrigado, e quaisquer d\u00favidas, sugest\u00f5es, elogios e reclama\u00e7\u00f5es, &#8230; 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\/en-us\/data-migration\/sql-server\/database\/guide\" target=\"_blank\">https:\/\/learn.microsoft.com\/en-us\/data-migration\/sql-server\/database\/guide<\/a><\/li><\/ul>\n\n\n\n<ul><li><a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/pt-br\/data-migration\/\" target=\"_blank\">https:\/\/learn.microsoft.com\/pt-br\/data-migration\/<\/a><\/li><\/ul>\n\n\n\n<ul><li><a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/pt-br\/azure\/dms\/dms-overview\" target=\"_blank\">https:\/\/learn.microsoft.com\/pt-br\/azure\/dms\/dms-overview<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\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.<\/p>\n<p>Para migrar um database do On-Premise para o Azure SQL temos v\u00e1rias op\u00e7\u00f5es.<\/p>\n<p>Cada op\u00e7\u00e3o tem suas vantagens e desvantagens espec\u00edficas. Dependendo por exemplo do tamanho das databases, da complexidade do ambiente, do tempo aceit\u00e1vel de inatividade durante processo de migra\u00e7\u00e3o, dentre outros fatores.<\/p>\n<p>A princ\u00edpio escolhi tr\u00eas maneiras bastantes utilizadas para realizar a migra\u00e7\u00e3o de bases, e por isso vou dividir em 3 partes (tr\u00eas Post) para n\u00e3o ficar cansativo.<\/p>\n<p>S\u00e3o elas:<\/p>\n<p>Deploy Database to Microsoft Azure SQL Database<br \/>\nBackup bac com import<br \/>\nDMA<br \/>\nBora come\u00e7ar?!<\/p>\n<p>Iniciando a s\u00e9rie sobre Migra\u00e7\u00e3o On-Premise para Azure SQL, abordo hoje o m\u00e9todo \u2018Deploy Database to Microsoft Azure SQL Database\u2019. Vamos explorar as vantagens, desafios e um passo a passo detalhado para facilitar sua jornada para a nuvem.<\/p>\n<p>Deploy Database to Microsoft Azure SQL Database:<br \/>\nUma op\u00e7\u00e3o \u201cdireta\u201d do SQL Server Management Studio (SSMS) para migrar bancos para o Azure SQL Database.<\/p>\n<p>Vantagens:<\/p>\n<p>Simplicidade: O processo \u00e9 integrado ao SSMS, facilitando a migra\u00e7\u00e3o, sem a necessidade de ferramentas adicionais.<br \/>\nFamiliaridade: Administradores de banco de dados que j\u00e1 utilizam o SSMS encontrar\u00e3o familiaridade no processo, reduzindo a curva de aprendizado.<br \/>\nDesvantagens:<\/p>\n<p>Limita\u00e7\u00f5es de Tamanho: Bancos de dados muito grandes podem enfrentar dificuldades ou demorar mais tempo para serem migrados por esse m\u00e9todo.<br \/>\nDowntime: Durante a migra\u00e7\u00e3o, o banco de dados pode ficar indispon\u00edvel, o que pode n\u00e3o ser ideal para ambientes que exigem alta disponibilidade.<\/p>\n","protected":false},"author":1,"featured_media":1461,"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\/01\/banner.png?fit=616%2C520&ssl=1","jetpack-related-posts":[{"id":1580,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-de-banco-de-dados-on-premise-para-azure-sql-parte3\/","url_meta":{"origin":1406,"position":0},"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":1484,"url":"https:\/\/ederlelis.com.br\/blog\/migracao-on-premise-para-azure-sql-parte2\/","url_meta":{"origin":1406,"position":1},"title":"Migra\u00e7\u00e3o On-Premise para Azure SQL (PARTE2)","date":"fevereiro 8, 2025","format":false,"excerpt":"...Dando continuidade \u00e0 nossa s\u00e9rie sobre migra\u00e7\u00e3o de banco de dados on-premise. Se 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. 1) Deploy Database to Microsoft Azure SQL Database (link\u2026","rel":"","context":"Com 1 coment\u00e1rio","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/02\/banner.png?fit=474%2C422&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2062,"url":"https:\/\/ederlelis.com.br\/blog\/retrospectiva-ano-2025\/","url_meta":{"origin":1406,"position":2},"title":"Retrospectiva Ano 2025!","date":"janeiro 5, 2026","format":false,"excerpt":"Retrospectiva Ano 2025! Ol\u00e1, espero que voc\u00ea esteja bem! \ud83d\ude09 \u2728 Um ano de transi\u00e7\u00e3o, evolu\u00e7\u00e3o t\u00e9cnica e conex\u00f5es reais! Este ano resolvi fazer algo um pouco diferente: usar o LinkedIn Rewind como refer\u00eancia, mas trazendo mais detalhes e acontecimentos que marcaram meu 2025. \ud83c\udfaf Meta: Sa\u00fade Come\u00e7o pela mais\u2026","rel":"","context":"Em &quot;Retrospectiva&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2026\/01\/retrospectiva2025_final.png?fit=611%2C615&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":339,"url":"https:\/\/ederlelis.com.br\/blog\/restore-database-azure-usando-ssms\/","url_meta":{"origin":1406,"position":3},"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":1406,"position":4},"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":1324,"url":"https:\/\/ederlelis.com.br\/blog\/retrospectiva-ano-2024\/","url_meta":{"origin":1406,"position":5},"title":"Retrospectiva Ano 2024!","date":"janeiro 4, 2025","format":false,"excerpt":"Retrospectiva Ano 2024! Ol\u00e1, espero que voc\u00ea esteja bem! \ud83d\ude09 Vamos juntos para a Retrospectiva do Ano 2024. Como refer\u00eancia, vou usar a retrospectiva do ano passado para validar algumas metas que foram tra\u00e7adas e comparar se consegui alcan\u00e7\u00e1-las. Al\u00e9m do crescimento t\u00e9cnico, este ano provou o poder do aprendizado\u2026","rel":"","context":"Em &quot;Retrospectiva&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ederlelis.com.br\/blog\/wp-content\/uploads\/2025\/01\/retro2024.jpeg?fit=1080%2C881&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/1406"}],"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=1406"}],"version-history":[{"count":21,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/1406\/revisions"}],"predecessor-version":[{"id":1465,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/posts\/1406\/revisions\/1465"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media\/1461"}],"wp:attachment":[{"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ederlelis.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}