{"id":1749,"date":"2019-03-27T14:13:35","date_gmt":"2019-03-27T14:13:35","guid":{"rendered":"https:\/\/www.tiagoneves.net\/blog\/?p=1749"},"modified":"2019-03-27T16:14:09","modified_gmt":"2019-03-27T16:14:09","slug":"fim-do-suporte-sql-2008-migracao-dma-on-premisses-x-on-premisses-e-on-premisses-x-azure","status":"publish","type":"post","link":"https:\/\/www.tiagoneves.net\/blog\/fim-do-suporte-sql-2008-migracao-dma-on-premisses-x-on-premisses-e-on-premisses-x-azure\/","title":{"rendered":"Fim do Suporte SQL 2008 &#8211; Migra\u00e7\u00e3o DMA &#8211; On-Premises x On-Premises e On-Premises x Azure"},"content":{"rendered":"\n<p>Fala pessoal, tudo certo?<\/p>\n\n\n\n<p>No post de hoje vamos dar continuidade ao assunto do post\nanterior, que \u00e9 sobre o fim do suporte ao SQL Server 2008.<\/p>\n\n\n\n<p>No post anterior, n\u00f3s aprendemos um pouco sobre as vantagens de migrar o SQL Server 2008 para outra vers\u00e3o, preferencialmente para a vers\u00e3o mais nova (2017). Tamb\u00e9m podemos conhecer o <strong>DMA<\/strong> (<strong>Data Migration Assistant<\/strong>) e como ele pode nos auxiliar a fazer uma migra\u00e7\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-tiago-neves-dba-sql-server\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"KuyqRMhqPg\"><a href=\"https:\/\/www.tiagoneves.net\/blog\/fim-do-suporte-sql-server-2008-voce-esta-preparado\/\">Fim do Suporte SQL Server 2008. Voc\u00ea est\u00e1 preparado?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"https:\/\/www.tiagoneves.net\/blog\/fim-do-suporte-sql-server-2008-voce-esta-preparado\/embed\/#?secret=KuyqRMhqPg\" data-secret=\"KuyqRMhqPg\" width=\"600\" height=\"338\" title=\"&#8220;Fim do Suporte SQL Server 2008. Voc\u00ea est\u00e1 preparado?&#8221; &#8212; Tiago Neves - DBA SQL Server\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Agora vamos fazer uma migra\u00e7\u00e3o de uma inst\u00e2ncia On-Premises para outro servidor On-Premises na pr\u00e1tica e um passo a passo para migrar os dados para o <strong>Azure SQL Database<\/strong> utilizando o DMA.<\/p>\n\n\n\n<p><strong>Migra\u00e7\u00e3o utilizando o DMA (Data Migration Assistant)<\/strong><\/p>\n\n\n\n<p>Abrir o DMA.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"362\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma001.png?resize=678%2C362&#038;ssl=1\" alt=\"\" class=\"wp-image-1713\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma001.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma001.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma001.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma001.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma001.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p>Agora vamos criar um novo projeto de migra\u00e7\u00e3o. Para isso vamos clicar no \u201c<strong>+<\/strong>\u201d, e selecionar \u201c<strong>Migration<\/strong>\u201d<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-009.png?resize=351%2C751&#038;ssl=1\" alt=\"\" class=\"wp-image-1715\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-009.png?w=351&amp;ssl=1 351w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-009.png?resize=140%2C300&amp;ssl=1 140w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/figure><\/div>\n\n\n\n<p style=\"text-align:left\">O pr\u00f3ximo passo \u00e9 selecionar o nome do projeto e qual \u00e9 a origem dos dados, no nosso caso ser\u00e1 SQL Server mesmo. Tamb\u00e9m precisamos informar qual \u00e9 o destino do no nosso banco de dados, se \u00e9 para o Azure ou outro SQL Server e por fim vamos informar o escopo da migra\u00e7\u00e3o, que basicamente \u00e9 informar o que vamos migrar (Data and Schema, Schema Only e Data Only).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"722\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma003.png?resize=351%2C722&#038;ssl=1\" alt=\"\" class=\"wp-image-1716\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma003.png?w=351&amp;ssl=1 351w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma003.png?resize=146%2C300&amp;ssl=1 146w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/figure><\/div>\n\n\n\n<p>Agora precisamos informar os servidores de origem e destino e tamb\u00e9m as credenciais. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"589\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma004.png?resize=678%2C589&#038;ssl=1\" alt=\"\" class=\"wp-image-1717\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma004.png?w=685&amp;ssl=1 685w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma004.png?resize=300%2C261&amp;ssl=1 300w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p><strong>*Obs:<\/strong><\/p>\n\n\n\n<p>O\nusu\u00e1rio no servidor de <strong>origem<\/strong>\nprecisa ter acesso de <strong>CONTROL SERVER<\/strong>\ne na instancia de <strong>destino<\/strong> precisa\nser membro da role <strong>Sysadmin<\/strong>.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Neste passo vamos selecionar quais bases vamos migrar, informar um caminho para o backup (certifique-se que ambos os servidores tem permiss\u00e3o de leitura e escrita no diret\u00f3rio de backup), e por fim vamos informar onde ficar\u00e3o os arquivos de <strong>dados<\/strong> e <strong>log, <\/strong>neste post vamos utilizar a base  StackOverflow.<\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma005.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1718\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma005.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma005.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma005.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma005.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma005.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p>Um dos grandes aux\u00edlios que o DMA nos d\u00e1 \u00e9 migrar os usu\u00e1rios do banco de dados para voc\u00ea. Neste passo voc\u00ea pode escolher quais usu\u00e1rios voc\u00ea quer migrar.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma006.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1719\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma006.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma006.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma006.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma006.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma006.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Progresso da migra\u00e7\u00e3o do banco de dados \u201c<strong>Stackoverflow<\/strong>\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i1.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma008.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1720\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma008.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma008.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma008.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma008.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma008.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Processo de restore da database em andamento no SQL22 via SSMS.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"309\" height=\"402\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma009.png?resize=309%2C402&#038;ssl=1\" alt=\"\" class=\"wp-image-1722\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma009.png?w=309&amp;ssl=1 309w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma009.png?resize=231%2C300&amp;ssl=1 231w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/figure><\/div>\n\n\n\n<p>Ap\u00f3s o restore ser conclu\u00eddo, ser\u00e1 apresentado um report da importa\u00e7\u00e3o dos dados e logins.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma010-1.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1723\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma010-1.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma010-1.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma010-1.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma010-1.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma010-1.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma011.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1724\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma011.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma011.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma011.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma011.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma011.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"296\" height=\"343\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma012.png?resize=296%2C343&#038;ssl=1\" alt=\"\" class=\"wp-image-1725\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma012.png?w=296&amp;ssl=1 296w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma012.png?resize=259%2C300&amp;ssl=1 259w\" sizes=\"auto, (max-width: 296px) 100vw, 296px\" \/><\/figure><\/div>\n\n\n\n<p>Bom pessoal, como podemos ver o DMA (Data Migration Assistant) \u00e9 uma ferramenta que nos auxilia a realizar uma migra\u00e7\u00e3o. Por\u00e9m, ela ainda deixa a desejar, pois ela <strong>n\u00e3o migra todos os objetos<\/strong>, somente o banco de dados e os usu\u00e1rios, j\u00e1 os demais objetos como Jobs, Linkedserver, Operadores e etc&#8230; voc\u00ea necessita migrar manualmente. Particularmente eu prefiro realizar uma migra\u00e7\u00e3o utilizando o conjunto de ferramentas do DBATools, que vou demonstrar no pr\u00f3ximo post. <\/p>\n\n\n\n<p><strong>Migrando um banco de dados para o Azure SQL Database<\/strong><\/p>\n\n\n\n<p>Se voc\u00ea ainda n\u00e3o sabe como criar um banco de dados Azure\nSQL Database, voc\u00ea\npode ver no post \u201c<a href=\"https:\/\/www.tiagoneves.net\/blog\/criando-um-banco-de-dados-sqldatabase\/\">Criando\num banco de dados Azure SQL Database<\/a>\u201d.<\/p>\n\n\n\n<p>Bom, ap\u00f3s o banco estar criado agora vamos iniciar a migra\u00e7\u00e3o do nosso banco para o Azure SQL Database utilizando o DMA.<\/p>\n\n\n\n<p>O primeiro passo \u00e9 validar se existe alguma incompatibilidade do banco SQL Server 2008 R2, com o Azure SQL Database, para isso vamos realizar um novo Assessment.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"736\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-001-1.png?fit=678%2C365&amp;ssl=1\" alt=\"\" class=\"wp-image-1726\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-001-1.png?w=1366&amp;ssl=1 1366w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-001-1.png?resize=300%2C162&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-001-1.png?resize=768%2C414&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-001-1.png?resize=1024%2C552&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p>Vamos selecionar valida\u00e7\u00e3o de compatibilidade e sugest\u00e3o de utiliza\u00e7\u00e3o de features. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-002.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1727\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-002.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-002.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-002.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-002.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-002.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p>Devemos conectar no servidor que vamos validar a database e logo ap\u00f3s informar quais vamos validar. Neste caso vamos validar somente a \u201c<strong>Stackoverflow<\/strong>\u201d.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"304\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-004.png?resize=304%2C751&#038;ssl=1\" alt=\"\" class=\"wp-image-1728\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-004.png?w=304&amp;ssl=1 304w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-004.png?resize=121%2C300&amp;ssl=1 121w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"362\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-003.png?resize=678%2C362&#038;ssl=1\" alt=\"\" class=\"wp-image-1730\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-003.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-003.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-003.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-003.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-003.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p>Agora vamos iniciar a valida\u00e7\u00e3o.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i1.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-005-1.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1731\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-005-1.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-005-1.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-005-1.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-005-1.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-005-1.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<p>O DMA identificou que a minha instancia tem outros servi\u00e7os que n\u00e3o est\u00e3o dispon\u00edveis no Azure, como o <strong>Reporting Service e o Analysis Services<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-006.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1732\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-006.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-006.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-006.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-006.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-006.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i1.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-007.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1733\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-007.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-007.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-007.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-007.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-007.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>E relacionado aos problemas de compatibilidade, n\u00e3o temos nenhum alerta de \u201cMigration Blockers\u201d, somente um alerta com uma tabela que tem uma coluna com um tipo de dados que est\u00e1 marcado como deprecated. <strong>Ent\u00e3o podemos seguir com a migra\u00e7\u00e3o!<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-008.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1734\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-008.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-008.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-008.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-008.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-008.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Para realizar a migra\u00e7\u00e3o, vamos clicar no \u201c<strong>+<\/strong>\u201d, e selecionar \u201c<strong>Migration<\/strong>\u201d, dar um nome ao projeto de migra\u00e7\u00e3o, selecionar o tipo de dados da origem, no nosso caso \u201c<strong>SQL Server<\/strong>\u201d, informar o destino \u201c<strong>Azure SQL Database\u201d <\/strong>e por fim informar qual ser\u00e1 o escopo da migra\u00e7\u00e3o, se vamos migrar somente o schema ou somente os dados ou ambos.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-009-1.png?resize=351%2C751&#038;ssl=1\" alt=\"\" class=\"wp-image-1735\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-009-1.png?w=351&amp;ssl=1 351w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-009-1.png?resize=140%2C300&amp;ssl=1 140w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/figure><\/div>\n\n\n\n<p>Novamente vamos informar o servidor de origem e informar quais bases vamos migrar, no nosso caso vamos utilizar somente a \u201c<strong>Stackoverflow<\/strong>\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-010.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1736\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-010.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-010.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-010.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-010.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-010.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Neste passo vamos conectar na nossa conta do Azure SQL Database, possivelmente voc\u00ea precisar\u00e1 realizar o login com a sua conta do Azure e criar uma regra no firewall, ap\u00f3s conectar no Azure voc\u00ea vai selecionar o banco de destino. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-011.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1737\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-011.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-011.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-011.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-011.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-011.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Quando vamos migrar para o Azure, podemos selecionar quais tabelas que queremos migrar para n\u00e3o levar lixos indesej\u00e1veis. Novamente o assistente nos mostra o warning, do tipo de dados que est\u00e1 marcado como deprecated.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i1.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-012.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1738\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-012.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-012.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-012.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-012.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-012.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p> <strong>Obs: <\/strong>Neste post vou migrar somente as tabelas pequenas, para n\u00e3o deixar o custo (R$) muito alto&#8230; (Microsoft me da um voucher)&#8230; =D<\/p>\n\n\n\n<p>\u00c9 gerado um script das tabelas selecionadas, temos a op\u00e7\u00e3o de executar l\u00e1 no portal ou fazer pela ferramenta. Se optar pela ferramenta, clique em <strong>\u201cDeploy schema\u201d<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-013.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1739\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-013.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-013.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-013.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-013.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-013.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-014.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1740\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-014.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-014.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-014.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-014.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-014.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Pronto! As tabelas foram criadas com sucesso, agora falta apenas migrar os dados. <br>Ap\u00f3s a importa\u00e7\u00e3o dos dados, ser\u00e1 exibido um report com o status da migra\u00e7\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1409\" height=\"751\" src=\"https:\/\/i2.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-015.png?fit=678%2C362&amp;ssl=1\" alt=\"\" class=\"wp-image-1741\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-015.png?w=1409&amp;ssl=1 1409w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-015.png?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-015.png?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-015.png?resize=1024%2C546&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-015.png?w=1356&amp;ssl=1 1356w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure>\n\n\n\n<p>Como podemos observar, a migra\u00e7\u00e3o foi realizada com sucesso e os dados j\u00e1 est\u00e3o dispon\u00edveis no Azure SQL Database.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"501\" height=\"523\" src=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-016.png?resize=501%2C523&#038;ssl=1\" alt=\"\" class=\"wp-image-1742\" srcset=\"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-016.png?w=501&amp;ssl=1 501w, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Migracao_sql_server_with_dma-016.png?resize=287%2C300&amp;ssl=1 287w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><\/figure>\n\n\n\n<p>Bom pessoal, no post de hoje aprendemos um pouco mais sobre como o DMA pode nos auxiliar na hora de efetuar uma migra\u00e7\u00e3o do SQL Server, tanto para outro server On-premises como para o Azure SQL Database. <\/p>\n\n\n\n<p>No pr\u00f3ximo post, vou demonstrar como realizar uma migra\u00e7\u00e3o\nutilizando o <strong>DBATools<\/strong>. <\/p>\n\n\n\n<p>Um abra\u00e7o e at\u00e9 a pr\u00f3xima.<\/p>\n\n\n\n<p>Tiago Neves<\/p>\n\n\n<p><!--EndFragment--><\/p>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Dando sequencia a s\u00e9rie de post sobre o fim do suporte ao SQL Server 2008 e SQL Server 2008 R2, neste post mostro como o DMA, pode nos auxiliar a realizar uma migra\u00e7\u00e3o tanto no SQL Server On-Premises como para o Azure SQL Database.<\/p>\n","protected":false},"author":1,"featured_media":1691,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"twitter_91251433_91251433":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Dando sequencia a s\u00e9rie de post sobre o fim do suporte ao SQL Server 2008 e SQL Server 2008 R2, neste post mostro como o DMA, pode nos auxiliar a realizar uma migra\u00e7\u00e3o tanto no SQL Server On-Premisses como para o Azure SQL Database.","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpscppro_dont_share_socialmedia":false,"_wpscppro_custom_social_share_image":0,"_facebook_share_type":"","_twitter_share_type":"","_linkedin_share_type":"","_pinterest_share_type":"","_linkedin_share_type_page":"","_instagram_share_type":"","_medium_share_type":"","_threads_share_type":"","_google_business_share_type":"","_selected_social_profile":[],"_wpsp_enable_custom_social_template":false,"_wpsp_social_scheduling":{"enabled":false,"datetime":null,"platforms":[],"status":"template_only","dateOption":"today","timeOption":"now","customDays":"","customHours":"","customDate":"","customTime":"","schedulingType":"absolute"},"_wpsp_active_default_template":true},"categories":[212,44,20],"tags":[236,95,255,256,254,87,65],"class_list":["post-1749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-microsoft","category-sqlserver-geral","tag-teamfabriciolima","tag-alwayson","tag-datamigration","tag-dma","tag-fimdosuporte","tag-migracao","tag-seguranca"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2019\/03\/Ending_Support_Of_SQLServer2008.png?fit=282%2C179&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6eIyh-sd","jetpack-related-posts":[{"id":2414,"url":"https:\/\/www.tiagoneves.net\/blog\/sql-server-2016-esta-chegando-ao-fim-do-suporte-o-que-isso-significa-na-pratica\/","url_meta":{"origin":1749,"position":0},"title":"SQL Server 2016 est\u00e1 chegando ao fim do suporte: o que isso significa na pr\u00e1tica?","author":"tiagoneves","date":"27 de abril de 2026","format":false,"excerpt":"O SQL Server 2016 ter\u00e1 seu suporte estendido encerrado em 14 de julho de 2026, o que resultar\u00e1 na falta de atualiza\u00e7\u00f5es de seguran\u00e7a e suporte. Continuar usando essa vers\u00e3o traz riscos como vulnerabilidades e n\u00e3o conformidade regulat\u00f3ria. Planejar a migra\u00e7\u00e3o para vers\u00f5es mais recentes ou cloud deve ser prioridade\u2026","rel":"","context":"Em &quot;Seguran\u00e7a&quot;","block_context":{"text":"Seguran\u00e7a","link":"https:\/\/www.tiagoneves.net\/blog\/category\/seguranca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.tiagoneves.net\/blog\/wp-content\/uploads\/2026\/04\/sql_server_2016_eos_v3.png?fit=772%2C702&ssl=1&resize=700%2C400 2x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/1749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/comments?post=1749"}],"version-history":[{"count":5,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/1749\/revisions"}],"predecessor-version":[{"id":1756,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/posts\/1749\/revisions\/1756"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/media\/1691"}],"wp:attachment":[{"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/media?parent=1749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/categories?post=1749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiagoneves.net\/blog\/wp-json\/wp\/v2\/tags?post=1749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}