{"id":11858,"date":"2021-10-26T00:00:16","date_gmt":"2021-10-26T07:00:16","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=11858"},"modified":"2024-03-01T09:10:09","modified_gmt":"2024-03-01T17:10:09","slug":"your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/","title":{"rendered":"Seu guia para sincronizar dados entre o Couchbase e bancos de dados relacionais com o GlueSync"},"content":{"rendered":"<h2 class=\"wp-block-heading\" id=\"h-introduction\"><span style=\"font-weight: 400\">Introdu\u00e7\u00e3o<\/span><\/h2>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Voc\u00ea est\u00e1 modernizando seu processo de desenvolvimento? Est\u00e1 seguindo uma abordagem de desenvolvimento r\u00e1pido para oferecer recursos de maior qualidade e mais frequentes aos seus clientes? Parte desse processo geralmente exige que trabalhemos com v\u00e1rios bancos de dados durante um per\u00edodo de transi\u00e7\u00e3o, quando precisamos de ambos os bancos de dados dispon\u00edveis. Precisamos de uma maneira de sincronizar os dados entre os bancos de dados. Usando o Couchbase com <a href=\"https:\/\/gluesync.com\/\">GlueSync<\/a><\/span><span style=\"font-weight: 400\"> se encaixa nesse prop\u00f3sito.\u00a0<\/span><\/p>\r\n\r\n\r\n<hr class=\"wp-block-separator\" \/>\r\n\r\n\r\n<p><em><span style=\"font-weight: 400\">O GlueSync permite que voc\u00ea replique dados de e para RDBMS (Microsoft SQL Server e Oracle) em tempo real com o Couchbase.<\/span><\/em><\/p>\r\n\r\n\r\n<hr class=\"wp-block-separator\" \/>\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Usaremos o Docker nesta postagem enquanto percorremos as etapas para instalar e configurar o Couchbase, o Microsoft SQL Server e o GlueSync, demonstrando a sincroniza\u00e7\u00e3o de dados entre os dois.<\/span><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-before-we-get-started\"><span style=\"font-weight: 400\">Antes de come\u00e7armos<\/span><\/h2>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-docker\"><span style=\"font-weight: 400\">Docker<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Primeiro, este tutorial usa o Docker e, se voc\u00ea n\u00e3o tiver o Docker, poder\u00e1 encontrar mais informa\u00e7\u00f5es aqui <\/span><a href=\"https:\/\/www.docker.com\/\"><span style=\"font-weight: 400\">https:\/\/www.docker.com\/<\/span><\/a><span style=\"font-weight: 400\">. Voc\u00ea precisar\u00e1 instalar o Docker para concluir as etapas abaixo.<\/span><\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-gluesync\"><span style=\"font-weight: 400\">GlueSync<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Em seguida, a GlueSync requer uma licen\u00e7a. Para concluir este tutorial, voc\u00ea precisar\u00e1 de uma licen\u00e7a da equipe da GlueSync. Voc\u00ea pode ir para <\/span><a href=\"https:\/\/gluesync.com\/plans\/\"><span style=\"font-weight: 400\">https:\/\/gluesync.com\/plans\/<\/span><\/a><span style=\"font-weight: 400\"> e veja mais informa\u00e7\u00f5es sobre seus planos e <\/span><a href=\"https:\/\/gluesync.com\/contact-sales\/\"><span style=\"font-weight: 400\">https:\/\/gluesync.com\/contact-sales\/<\/span><\/a><span style=\"font-weight: 400\"> para entrar em contato com a equipe da GlueSync.<\/span><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-high-level-steps\"><span style=\"font-weight: 400\">Etapas de alto n\u00edvel<\/span><\/h2>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li><a href=\"#h-run-couchbase-and-mssql\"><span style=\"font-weight: 400\">Executar e configurar o Couchbase e o MSSQL<\/span><\/a><\/li>\r\n<li><span style=\"font-weight: 400\"><a href=\"#h-configure-and-run-gluesync-for-couchbase-to-mssql\">Criar o arquivo de configura\u00e7\u00e3o para o GlueSync<\/a><\/span><\/li>\r\n<li><a href=\"#h-configure-and-run-gluesync-for-couchbase-to-mssql\"><span style=\"font-weight: 400\">Configurar e executar o GlueSync para Couchbase para MSSQL<\/span><\/a><\/li>\r\n<li><span style=\"font-weight: 400\"><a href=\"#h-watch-the-magic\">Veja a m\u00e1gica<\/a><\/span><\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-run-couchbase-and-mssql\"><span style=\"font-weight: 400\">Executar o Couchbase e o MSSQL<\/span><\/h2>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-couchbase\"><span style=\"font-weight: 400\">Couchbase<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Usaremos o Couchbase 6.6.3 para este tutorial. O seguinte comando do Docker colocar\u00e1 o Couchbase em funcionamento, expondo as portas de que precisamos.<\/span><\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">docker run -d --name cb-663 -p 8091-8096:8091-8096 -p 11210-11211:11210-11211 couchbase:enterprise-6.6.3<\/pre>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-mssql\"><span style=\"font-weight: 400\">MSSQL<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Para o comando MSSQL Docker run, observe que estamos incluindo a senha SA. Atualize-a e anote-a, pois a usaremos mais tarde.<\/span><\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">docker run -d --name mssql -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=RandomMSSQLPass2!' -p 1433:1433 -d mcr.microsoft.com\/mssql\/server:2019-CU10-ubuntu-20.04<\/pre>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-verify-containers\"><span style=\"font-weight: 400\">Verificar cont\u00eaineres<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Agora voc\u00ea deve ter dois cont\u00eaineres em execu\u00e7\u00e3o, o Couchbase e o MSSQL. Iniciaremos o cont\u00eainer da GlueSync depois de configur\u00e1-los.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11865\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image23-300x56.png\" alt=\"\" width=\"782\" height=\"146\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image23-300x56.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image23-1024x190.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image23-768x143.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image23-20x4.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image23.png 1269w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-configure-couchbase-and-mssql\"><span style=\"font-weight: 400\">Configurar o Couchbase com GlueSync e MSSQL<\/span><\/h2>\r\n\r\n\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Come\u00e7aremos com o Couchbase e faremos uma instala\u00e7\u00e3o b\u00e1sica.<\/span><\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-setup-new-cluster\"><span style=\"font-weight: 400\">Configurar novo cluster<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">A execu\u00e7\u00e3o dos comandos do Docker acima teria iniciado o Couchbase e exposto as portas para que voc\u00ea possa abrir<\/span><span style=\"font-weight: 400\"> na interface do usu\u00e1rio do Couchbase, acessando <\/span><a href=\"https:\/\/localhost:8091\/ui\/index.html\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400\">https:\/\/localhost:8091\/ui\/index.html<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">N\u00f3s escolheremos <\/span><b>Configurar novo cluster<\/b><span style=\"font-weight: 400\"> e configurar um cluster de um n\u00f3 (n\u00e3o recomendado para produ\u00e7\u00e3o, mas funciona muito bem para desenvolvimento e para fazer um tutorial).\u00a0<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11872\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image30-300x208.png\" alt=\"\" width=\"449\" height=\"311\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image30-300x208.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image30-20x14.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image30.png 545w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Digite as informa\u00e7\u00f5es do novo cluster e clique em <\/span><b>Pr\u00f3ximo: Aceitar termos<\/b><span style=\"font-weight: 400\">. Anote sua senha, pois precisaremos dela mais tarde. Estamos usando <\/span><b>RandomCBPass2!<\/b><span style=\"font-weight: 400\"> para essa inst\u00e2ncia.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11890\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image16-300x210.png\" alt=\"\" width=\"473\" height=\"331\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image16-300x210.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image16-20x14.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image16.png 548w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Se voc\u00ea aceitar os termos e condi\u00e7\u00f5es, marque essa op\u00e7\u00e3o e clique em <\/span><b>Finalizar com padr\u00f5es<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<p><b>OBSERVA\u00c7\u00c3O<\/b><span style=\"font-weight: 400\"> O GlueSync funciona com o Couchbase usando algumas tecnologias do Couchbase, o Sync Gateway e o servi\u00e7o Eventing. Neste tutorial, estamos usando a op\u00e7\u00e3o Eventing. O recurso Eventing ser\u00e1 instalado com a op\u00e7\u00e3o <\/span><b>Finalizar com padr\u00f5es<\/b><span style=\"font-weight: 400\"> sele\u00e7\u00e3o abaixo.\u00a0<\/span><\/p>\r\n\r\n\r\n<hr class=\"wp-block-separator\" \/>\r\n\r\n\r\n<p><em><span style=\"font-weight: 400\">O Couchbase oferece uma instala\u00e7\u00e3o \u00fanica em que voc\u00ea pode ativar todos os servi\u00e7os ou escolher e personalizar de acordo com as necessidades do seu projeto. Este tutorial instalar\u00e1 todos os servi\u00e7os por conveni\u00eancia. <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/services.html\">Saiba mais<\/a> sobre os servi\u00e7os do Couchbase e o dimensionamento multidimensional<\/span><span style=\"font-weight: 400\">.\u00a0\u00a0<\/span><\/em><\/p>\r\n\r\n\r\n<hr class=\"wp-block-separator\" \/>\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11876\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image2-244x300.png\" alt=\"\" width=\"501\" height=\"616\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image2-244x300.png 244w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image2-300x368.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image2-16x20.png 16w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image2.png 550w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Voc\u00ea dever\u00e1 ser redirecionado para o Dashboard. Neste tutorial, usaremos os dados do bucket de amostra. Para instalar os dados, clique em <\/span><b>Baldes de amostra<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Se, por algum motivo, voc\u00ea n\u00e3o estiver vendo o <\/span><b>Balde de amostras<\/b><span style=\"font-weight: 400\"> no painel de controle, v\u00e1 para <\/span><b>Configura\u00e7\u00f5es <\/b><span style=\"font-weight: 400\">no menu esquerdo, procure no canto superior direito da interface do usu\u00e1rio e voc\u00ea ver\u00e1 um item de menu para <\/span><b>Baldes de amostra<\/b><span style=\"font-weight: 400\">conforme mostrado abaixo.\u00a0<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11879\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image5-300x68.png\" alt=\"\" width=\"768\" height=\"174\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image5-300x68.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image5-1024x231.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image5-768x174.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image5-20x5.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image5.png 1270w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Verifique a amostra de cerveja e clique em <\/span><b>Carregar dados de amostra<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11891\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image17-300x116.png\" alt=\"\" width=\"631\" height=\"244\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image17-300x116.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image17-768x298.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image17-20x8.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image17.png 1003w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Aguarde alguns minutos para carregar e clique em <\/span><b>Baldes<\/b><span style=\"font-weight: 400\"> na navega\u00e7\u00e3o \u00e0 esquerda.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">\u00a0<\/span><span style=\"font-weight: 400\">Voc\u00ea deveria ver o balde de amostras de cerveja que acabamos de carregar.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11875\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image1-300x81.png\" alt=\"\" width=\"719\" height=\"194\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image1-300x81.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image1-1024x275.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image1-768x206.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image1-20x5.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image1.png 1274w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Vamos visualizar os documentos. Clique no \u00edcone <\/span><b>Documentos<\/b><span style=\"font-weight: 400\"> no link \u00e0 direita, ao lado de <\/span><b>Estat\u00edsticas<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Vamos sincronizar documentos do tipo cerveja. Voc\u00ea pode colocar um filtro (type=\"beer\") na caixa N1QL WHERE e clicar em <\/span><b>Recuperar documentos<\/b><span style=\"font-weight: 400\"> para obter esses documentos; ser\u00e1 um pouco mais f\u00e1cil ver e testar dessa forma.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11873\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image31-300x89.png\" alt=\"\" width=\"735\" height=\"218\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image31-300x89.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image31-1024x303.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image31-768x228.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image31-20x6.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image31-1320x391.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image31.png 1495w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-create-couchbase-user\">Criar usu\u00e1rio do Couchbase<\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Criaremos um usu\u00e1rio para ser usado pelo aplicativo GlueSync. Isso \u00e9 para fins de tutorial e voc\u00ea deve seguir suas pr\u00e1ticas de seguran\u00e7a ao gerenciar seus usu\u00e1rios em conjunto com os requisitos do Couchbase e da GlueSync.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Ir para o <\/span><b>Seguran\u00e7a<\/b><span style=\"font-weight: 400\"> no link \u00e0 esquerda e clique em <\/span><b>ADICIONAR USU\u00c1RIO<\/b><span style=\"font-weight: 400\"> no canto superior direito.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11893\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image19-300x79.png\" alt=\"\" width=\"722\" height=\"190\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image19-300x79.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image19-1024x269.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image19-768x202.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image19-20x5.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image19-1320x347.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image19.png 1500w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Preencha as informa\u00e7\u00f5es do usu\u00e1rio, conforme mostrado abaixo. Estamos usando o nome de usu\u00e1rio de <\/span><b>cb-usu\u00e1rio<\/b><span style=\"font-weight: 400\"> e senha <\/span><b>RandomCBPass2!<\/b><span style=\"font-weight: 400\">Guarde essas informa\u00e7\u00f5es para mais tarde. Certifique-se de verificar <\/span><b>Administra\u00e7\u00e3o completa<\/b><span style=\"font-weight: 400\"> sob as fun\u00e7\u00f5es. Depois de preenchido, clique no bot\u00e3o <\/span><b>Adicionar usu\u00e1rio<\/b><span style=\"font-weight: 400\"> bot\u00e3o.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11887\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image13-300x258.png\" alt=\"\" width=\"547\" height=\"470\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image13-300x258.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image13-20x17.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image13.png 642w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Voc\u00ea ver\u00e1 o usu\u00e1rio que acabamos de criar.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11889\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image15-300x59.png\" alt=\"\" width=\"915\" height=\"180\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image15-300x59.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image15-1024x200.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image15-768x150.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image15-20x4.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image15-1320x258.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image15.png 1495w\" sizes=\"auto, (max-width: 915px) 100vw, 915px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-add-a-gluesync-metadata-bucket\"><span style=\"font-weight: 400\">Adicionar um bucket de metadados do GlueSync<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">O GlueSync usa o servi\u00e7o Eventing do Couchbase. O Eventing requer um bucket de metadados, e vamos criar um agora. <a href=\"https:\/\/gluesync.com\/docs\/gluesync\/v1.2.0\/couchbase-server\/bucket-requirements.html#metadata-bucket\">Obter mais informa\u00e7\u00f5es<\/a> no GlueSync e no bucket de metadados.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Ir para <\/span><b>Baldes <\/b><span style=\"font-weight: 400\">no menu \u00e0 esquerda e clique em <\/span><b>ADICIONAR BALDE<\/b><span style=\"font-weight: 400\"> no canto superior direito.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11863\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image21-300x78.png\" alt=\"\" width=\"846\" height=\"220\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image21-300x78.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image21-1024x268.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image21-768x201.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image21-20x5.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image21-1320x345.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image21.png 1488w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Digite o nome dos metadados e clique em <\/span><b>Adicionar balde<\/b><span style=\"font-weight: 400\">. Usaremos os padr\u00f5es para as outras op\u00e7\u00f5es.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11878\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image4-300x257.png\" alt=\"\" width=\"604\" height=\"517\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image4-300x257.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image4-20x17.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image4.png 542w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Voc\u00ea deve ver dois baldes agora.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11885\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image11-300x87.png\" alt=\"\" width=\"828\" height=\"240\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image11-300x87.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image11-768x222.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image11-20x6.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image11.png 808w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-mssql-1\"><span style=\"font-weight: 400\">MSSQL<\/span><\/h2>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Usaremos o SQL Server Management Studio para configurar o MSSQL, que foi instalado na etapa acima. Se precisar instalar o Management Studio, voc\u00ea pode <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-ver15\">encontre-o aqui<\/a>.<\/span><b>\u00a0<\/b><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Fa\u00e7a login com as credenciais passadas para o comando do Docker na etapa anterior, neste caso, Login: <\/span><b>sa<\/b><span style=\"font-weight: 400\"> e Senha: <\/span><b>RandomMSSQLPass2!<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11886\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image12-300x201.png\" alt=\"\" width=\"603\" height=\"404\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image12-300x201.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image12-400x267.png 400w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image12-450x300.png 450w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image12-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image12.png 498w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-create-new-database\"><span style=\"font-weight: 400\">Criar novo banco de dados<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Criaremos um novo banco de dados no qual os dados do Couchbase ser\u00e3o carregados.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11870\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image28-279x300.png\" alt=\"\" width=\"459\" height=\"493\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image28-279x300.png 279w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image28-300x322.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image28-20x20.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image28.png 324w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Nesse caso, como sou muito criativo, usarei <\/span><b>cb<\/b><span style=\"font-weight: 400\">e selecione Ok.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11871\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image29-300x113.png\" alt=\"\" width=\"685\" height=\"258\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image29-300x113.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image29-20x8.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image29.png 693w\" sizes=\"auto, (max-width: 685px) 100vw, 685px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-create-login\"><span style=\"font-weight: 400\">Criar login<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Em seguida, crie um login MSSQL. Clique com o bot\u00e3o direito do mouse na pasta Login e selecione <\/span><b>Novo login...<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11864\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image22-300x243.png\" alt=\"\" width=\"531\" height=\"430\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image22-300x243.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image22-20x16.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image22.png 349w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">O nome de login que estamos usando \u00e9 <\/span><b>mssql-user <\/b><span style=\"font-weight: 400\">e a senha \u00e9 <\/span><b>RandomMSSQLUserPass2!<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Definir o banco de dados padr\u00e3o como <\/span><b>cb<\/b><span style=\"font-weight: 400\">no banco de dados criado acima.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Voc\u00ea deve seguir seus padr\u00f5es de seguran\u00e7a ao criar usu\u00e1rios. As instru\u00e7\u00f5es neste artigo s\u00e3o apenas para fins de tutorial e algumas op\u00e7\u00f5es que escolhi s\u00e3o para simplificar. <\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11867\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image25-300x284.png\" alt=\"\" width=\"627\" height=\"594\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image25-300x284.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image25-20x20.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image25.png 696w\" sizes=\"auto, (max-width: 627px) 100vw, 627px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Ir para <\/span><b>Mapeamento de usu\u00e1rios<\/b><span style=\"font-weight: 400\">, \u00e0 esquerda sob <\/span><b>Selecione uma p\u00e1gina<\/b><span style=\"font-weight: 400\">e selecione <\/span><b>cb <\/b><span style=\"font-weight: 400\">sob <\/span><b>Usu\u00e1rios mapeados para este login<\/b><span style=\"font-weight: 400\"> e <\/span><b>Propriet\u00e1rio do banco de dados<\/b><span style=\"font-weight: 400\"> sob o <\/span><b>Participa\u00e7\u00e3o na fun\u00e7\u00e3o do banco de dados<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11862\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image20-300x284.png\" alt=\"\" width=\"631\" height=\"597\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image20-300x284.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image20-20x20.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image20.png 693w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Agora que temos essa configura\u00e7\u00e3o, verifique se voc\u00ea pode fazer login com o usu\u00e1rio. Fa\u00e7a logout do sa e fa\u00e7a login novamente com o novo usu\u00e1rio.<\/span><\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-create-table\"><span style=\"font-weight: 400\">Criar tabela<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Vamos criar uma tabela para os dados a serem sincronizados, a partir do Couchbase. V\u00e1 para a tabela <\/span><b>Bancos de dados<\/b><span style=\"font-weight: 400\">, ent\u00e3o <\/span><b>cb<\/b><span style=\"font-weight: 400\">e, em seguida, abra um <\/span><b>Nova consulta<\/b><span style=\"font-weight: 400\"> janela. Os campos dessa tabela correspondem aos atributos do documento beer-samples do Couchbase. O SQL para criar a tabela est\u00e1 abaixo.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11874\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image32-300x140.png\" alt=\"\" width=\"891\" height=\"416\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image32-300x140.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image32-768x358.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image32-20x9.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image32.png 985w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Execute o comando create table.<\/span><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\r\n\r\n\r\n\r\n<div>\r\n<pre>create\u00a0table\u00a0beer\r\n(\r\n \u00a0\u00a0\u00a0name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0varchar(200)\u00a0\u00a0not\u00a0null\u00a0constraint\u00a0beer_pk\u00a0primary\u00a0key\u00a0nonclustered,\r\n \u00a0\u00a0\u00a0abv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0numeric(5,\u00a02)\u00a0not\u00a0null,\r\n \u00a0\u00a0\u00a0brewery_id\u00a0\u00a0varchar(max)\u00a0\u00a0not\u00a0null,\r\n \u00a0\u00a0\u00a0category\u00a0\u00a0\u00a0\u00a0varchar(max),\r\n \u00a0\u00a0\u00a0description\u00a0varchar(max)\u00a0\u00a0not\u00a0null,\r\n \u00a0\u00a0\u00a0ibu\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0int\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0not\u00a0null,\r\n \u00a0\u00a0\u00a0srm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0int\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0not\u00a0null,\r\n \u00a0\u00a0\u00a0style\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0varchar(max),\r\n \u00a0\u00a0\u00a0upc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0int\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0not\u00a0null,\r\n \u00a0\u00a0\u00a0updated\u00a0\u00a0\u00a0\u00a0\u00a0varchar(max)\u00a0\u00a0not\u00a0null\r\n)\r\ngo<\/pre>\r\n<\/div>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-configure-and-run-gluesync-for-couchbase-to-mssql\"><span style=\"font-weight: 400\">Configurar e executar o GlueSync para Couchbase para MSSQL<\/span><\/h2>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">O GlueSync tem dois componentes, um para o Couchbase para o MSSQL e outro para o MSSQL para o Couchbase. Isso configurar\u00e1 o aplicativo para sincronizar os dados do Couchbase com o MSSQL. A configura\u00e7\u00e3o da outra dire\u00e7\u00e3o \u00e9 muito semelhante.\u00a0 \u00a0<\/span><\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-make-config-folder\"><span style=\"font-weight: 400\">Criar pasta de configura\u00e7\u00e3o<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Crie uma pasta para o arquivo de configura\u00e7\u00e3o do GlueSync. Compartilharemos isso com o cont\u00eainer do Docker ao inici\u00e1-lo.<\/span><\/p>\r\n\r\n\r\n\r\n<div>\r\n<pre>mkdir\u00a0c:\\a\\gluesync\\config<\/pre>\r\n<div>\u00a0<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-get-docker-network-ip-addresses-for-couchbase-and-mssql\"><span style=\"font-weight: 400\">Obter endere\u00e7os IP de rede do Docker para Couchbase e MSSQL<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Precisamos das informa\u00e7\u00f5es de rede do Docker para os cont\u00eaineres do Couchbase e do MSSQL para configurar o GlueSync.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Obtenha os IDs de cont\u00eaineres.<\/span><\/p>\r\n\r\n\r\n\r\n<div>\r\n<pre>C:\\Users\\David\u00a0Elliott&gt;\u00a0docker\u00a0container\u00a0ls\u00a0-a\r\nCONTAINER ID\u00a0\u00a0\u00a0IMAGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0COMMAND\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0CREATED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0PORTS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0NAMES\r\n10b985792024\u00a0\u00a0\u00a0mcr.microsoft.com\/mssql\/server:2019-CU10-ubuntu-20.04\u00a0\u00a0\u00a0\"\/opt\/mssql\/bin\/perm\u2026\"\u00a0\u00a0\u00a034 minutes ago\u00a0\u00a0\u00a0Up 34 minutes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00.0.0.0:1433-&gt;1433\/tcp, :::1433-&gt;1433\/tcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0mssql\r\nd2df1bad1647\u00a0\u00a0\u00a0couchbase:enterprise-6.6.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"\/entrypoint.sh couc\u2026\"\u00a0\u00a0\u00a040 minutes ago\u00a0\u00a0\u00a0Up 40 minutes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00.0.0.0:8091-8096-&gt;8091-8096\/tcp, :::8091-8096-&gt;8091-8096\/tcp, 11207\/tcp, 0.0.0.0:11210-11211-&gt;11210-11211\/tcp, :::11210-11211-&gt;11210-11211\/tcp, 18091-18096\/tcp\u00a0\u00a0\u00a0cb-663<\/pre>\r\n<\/div>\r\n\r\n\r\n\r\n<div>\r\n<p>Agora, obtenha os endere\u00e7os IP dos cont\u00eaineres que usam esses IDs usando o comando Docker Inspect no Couchbase.<\/p>\r\n<\/div>\r\n\r\n\r\n\r\n<div>\r\n<pre>C:\\Users\\David\u00a0Elliott&gt;\u00a0docker\u00a0inspect\u00a0d2df1bad1647\u00a0|\u00a0Select-String\u00a0IPAddress\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"SecondaryIPAddresses\":\u00a0null,\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"IPAddress\":\u00a0\"172.17.0.2\",\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"IPAddress\": \"172.17.0.2\",<\/pre>\r\n<p><span style=\"font-weight: 400\">Execute o comando Docker Inspect no MSSQL.<\/span><\/p>\r\n<\/div>\r\n\r\n\r\n\r\n<div>\r\n<div>\r\n<pre>C:\\Users\\David\u00a0Elliott&gt;\u00a0docker\u00a0inspect\u00a010b985792024\u00a0|\u00a0Select-String\u00a0IPAddress\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"SecondaryIPAddresses\":\u00a0null,\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"IPAddress\":\u00a0\"172.17.0.3\",\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"IPAddress\":\u00a0\"172.17.0.3\",<\/pre>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Os endere\u00e7os IP s\u00e3o:<\/span><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Couchbase - 172.17.0.2<\/span><\/li>\r\n<li><span style=\"font-weight: 400\">MSSQL - 172.17.0.3<\/span><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>OBSERVA\u00c7\u00c3O: se voc\u00ea parar e reiniciar os cont\u00eaineres, o endere\u00e7o IP poder\u00e1 mudar e ser\u00e1 necess\u00e1rio verificar se a configura\u00e7\u00e3o ainda est\u00e1 correta.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-create-the-gluesync-configuration-file\"><span style=\"font-weight: 400\">Criar o arquivo de configura\u00e7\u00e3o da GlueSync<\/span><\/h3>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Atualize as informa\u00e7\u00f5es abaixo com suas informa\u00e7\u00f5es espec\u00edficas e salve-as no arquivo config.json na pasta que voc\u00ea criou acima, ou seja, c:\\a\\gluesync\\config\\config.json<\/span><\/p>\r\n\r\n\r\n\r\n<div>\r\n<pre>{\r\n \u00a0\"sourceHost\":\u00a0\"172.17.0.2\",\r\n \u00a0\"sourcePort\":\u00a0\"8091\",\r\n \u00a0\"sourceName\":\u00a0\"beer-sample\",\r\n \u00a0\"sourceUsername\":\u00a0\"cb-user\",\r\n \u00a0\"sourcePassword\":\u00a0\"RandomCBPass2!\",\r\n \u00a0\"sourceEntities\":\u00a0{\r\n \u00a0\u00a0\u00a0\"beer\":\u00a0{}\r\n \u00a0},\r\n \u00a0\"sourceChangeRetention\":\u00a05,\r\n \u00a0\"copySourceEntitiesAtStartup\":\u00a0true,\r\n \u00a0\"targetHost\":\u00a0\"172.17.0.3\",\r\n \u00a0\"targetPort\":\u00a0\"1433\",\r\n \u00a0\"targetName\":\u00a0\"cb\",\r\n \u00a0\"targetUsername\":\u00a0\"mssql-user\",\r\n \u00a0\"targetPassword\":\u00a0\"RandomMSSQLUserPass2!\",\r\n \u00a0\"maxItemsCountPerTransaction\":\u00a0100,\r\n \u00a0\"maxTransactionCountPerIteration\":\u00a0100,\r\n \u00a0\"couchbase\":\u00a0{\r\n \u00a0\u00a0\u00a0\"timeoutSeconds\":\u00a060,\r\n \u00a0\u00a0\u00a0\"indexReplicaCount\":\u00a00,\r\n \u00a0\u00a0\u00a0\"eventing\":\u00a0{\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\"baseUrl\":\u00a0\"https:\/\/172.17.0.2\",\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\"metadataBucketName\":\u00a0\"Metadata\"\r\n \u00a0\u00a0\u00a0}\r\n \u00a0}\r\n}<\/pre>\r\n<\/div>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-get-gluesync-credentials-to-pull-gluesync-image-from-docker\"><span style=\"font-weight: 400\">Obter credenciais da GlueSync para extrair a imagem da GlueSync do Docker<\/span><\/h2>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Consulte a se\u00e7\u00e3o Antes de come\u00e7ar acima para obter informa\u00e7\u00f5es sobre a licen\u00e7a do GlueSync para o registro do Docker e fazer o download do produto.\u00a0<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Quando voc\u00ea tiver essas informa\u00e7\u00f5es, siga as etapas abaixo para instalar o GlueSync.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Como \u00e9 poss\u00edvel que voc\u00ea j\u00e1 tenha credenciais armazenadas, talvez queira fazer logout. Se voc\u00ea tiver problemas com as credenciais, esse pode ser o motivo.<\/span><\/p>\r\n\r\n\r\n\r\n<div>\r\n<pre>C:\\Users\\David\u00a0Elliott&gt;\u00a0docker\u00a0logout\u00a0registry.gitlab.com\r\nRemoving login credentials for registry.gitlab.com<\/pre>\r\n<p><span style=\"font-weight: 400\">Fa\u00e7a login no registro - esse pode ser um registro diferente do que voc\u00ea normalmente usa, portanto, verifique novamente esse valor.<\/span><\/p>\r\n<\/div>\r\n\r\n\r\n\r\n<div>\u00a0<\/div>\r\n\r\n\r\n\r\n<div>\r\n<div>\r\n<pre>C:\\Users\\David\u00a0Elliott&gt;\u00a0docker\u00a0login\u00a0registry.gitlab.com\r\nUsername: xxxusernamexxx\r\nPassword:\r\nLogin Succeeded<\/pre>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Puxe a imagem.<\/span><\/p>\r\n\r\n\r\n\r\n<div>\r\n<pre>C:\\Users\\David\u00a0Elliott&gt;\u00a0docker\u00a0pull\u00a0registry.gitlab.com\/molo17srl\/products\/gluesync\/nosql-to-sql-kotlin\/couchbase-to-mssql:latest\r\nlatest: Pulling from molo17srl\/products\/gluesync\/nosql-to-sql-kotlin\/couchbase-to-mssql\r\nDigest: sha256:55e476fa05853c9dc5dfc1263cd5d2a5d3e1ea98f69b4d15d8edb83b91dcb142\r\nStatus: Downloaded newer image for registry.gitlab.com\/molo17srl\/products\/gluesync\/nosql-to-sql-kotlin\/couchbase-to-mssql:latest\r\nregistry.gitlab.com\/molo17srl\/products\/gluesync\/nosql-to-sql-kotlin\/couchbase-to-mssql:latest\r\nC:\\Users\\David Elliott&gt;<\/pre>\r\n<p><span style=\"font-weight: 400\">Talvez voc\u00ea queira fazer o logout novamente (j\u00e1 me atrapalhei quando n\u00e3o fiz o logout e recebi erros na pr\u00f3xima vez que executei um comando).<\/span><\/p>\r\n<\/div>\r\n\r\n\r\n\r\n<div>\u00a0<\/div>\r\n\r\n\r\n\r\n<div>\r\n<div>\r\n<pre>C:\\Users\\David\u00a0Elliott&gt;\u00a0docker\u00a0logout\u00a0registry.gitlab.com\r\nRemoving login credentials for registry.gitlab.com<\/pre>\r\n<p><span style=\"font-weight: 400\">Inicie o cont\u00eainer\/aplicativo GlueSync<\/span><\/p>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Atualize o caminho para o arquivo de configura\u00e7\u00e3o no comando do Docker abaixo para corresponder ao caminho em seu computador.<\/span><\/p>\r\n\r\n\r\n\r\n<div>\r\n<pre>docker\u00a0run\u00a0-d\u00a0--name\u00a0gluesync-cb-to-mssql\u00a0-v\u00a0c:\/a\/gluesync\/config:\/opt\/app\/config\u00a0registry.gitlab.com\/molo17srl\/products\/gluesync\/nosql-to-sql-kotlin\/couchbase-to-mssql:1.2.3<\/pre>\r\n<\/div>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Voc\u00ea deve ter tr\u00eas cont\u00eaineres em execu\u00e7\u00e3o no Docker.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11888\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image14-300x70.png\" alt=\"\" width=\"926\" height=\"216\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image14-300x70.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image14-1024x239.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image14-768x179.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image14-20x5.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image14.png 1269w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Se ele n\u00e3o estiver em execu\u00e7\u00e3o, verifique se h\u00e1 mensagens nos registros do cont\u00eainer. Inadvertidamente, coloquei o arquivo de configura\u00e7\u00e3o na pasta errada e o GlueSync n\u00e3o foi iniciado; os registros me informaram o que estava acontecendo.<\/span><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-watch-the-magic\"><span style=\"font-weight: 400\">Veja a magia<\/span><\/h2>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">V\u00e1 para o MSSQL e consulte a tabela. Voc\u00ea dever\u00e1 ver os dados do bucket do Couchbase na tabela que criamos. Quando o GlueSync foi iniciado, ele sincronizou os dados do Couchbase com o MSSQL.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11866\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image24-300x107.png\" alt=\"\" width=\"922\" height=\"329\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image24-300x107.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image24-1024x364.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image24-768x273.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image24-1536x546.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image24-20x7.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image24-1320x469.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image24.png 1615w\" sizes=\"auto, (max-width: 922px) 100vw, 922px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Para brincar com isso, voc\u00ea pode modificar os dados e ver as altera\u00e7\u00f5es sincronizadas entre os bancos de dados. V\u00e1 para os documentos de amostras de cerveja e fa\u00e7a uma altera\u00e7\u00e3o. Aqui, atualizei dois documentos. Voc\u00ea pode ver o registro de sa\u00edda do Docker abaixo da interface do usu\u00e1rio do Couchbase. O GlueSync detectou as duas altera\u00e7\u00f5es.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11869\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image27-300x200.png\" alt=\"\" width=\"875\" height=\"583\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image27-300x200.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image27-1024x682.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image27-768x512.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image27-400x267.png 400w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image27-450x300.png 450w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image27-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image27.png 1297w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Ao mudar para o MSSQL, tamb\u00e9m posso ver as atualiza\u00e7\u00f5es no MSSQL.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11868\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image26-300x140.png\" alt=\"\" width=\"896\" height=\"418\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image26-300x140.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image26-1024x476.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image26-768x357.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image26-20x9.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/image26.png 1135w\" sizes=\"auto, (max-width: 896px) 100vw, 896px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><span style=\"font-weight: 400\">Conclus\u00e3o<\/span><\/h2>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Muitas vezes, temos de trabalhar com v\u00e1rios bancos de dados, principalmente quando estamos fazendo uma moderniza\u00e7\u00e3o. Podemos ter uma vers\u00e3o em fases ou precisar obter dados existentes de um banco de dados relacional mais antigo para o Couchbase. Isso pode envolver c\u00f3digo e testes personalizados ou considerar um produto como o GlueSync, que torna o processo mais simples.\u00a0<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400\">Checkout <a href=\"https:\/\/gluesync.com\/\">GlueSync <\/a><\/span><span style=\"font-weight: 400\">para obter mais informa\u00e7\u00f5es sobre seus produtos e recursos. <\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>Introduction Are you modernizing your development process? Are you following a rapid development approach to deliver higher quality and more frequent capabilities to your customers? Part of that process often requires us to work with multiple databases for a transition [&hellip;]<\/p>","protected":false},"author":76330,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1814,2242,1816,6319,2389],"tags":[],"ppma_author":[9391],"class_list":["post-11858","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-design","category-connectors","category-couchbase-server","category-customers","category-solutions"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v26.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sync Data Between Couchbase and Relational Databases<\/title>\n<meta name=\"description\" content=\"Go through the steps of how-to setup and configure Couchbase, Microsoft SQL Server, and GlueSync, demonstrating the syncing of data between the two.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/pt\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Your Guide to Syncing Data between Couchbase and Relational Databases with GlueSync\" \/>\n<meta property=\"og:description\" content=\"Go through the steps of how-to setup and configure Couchbase, Microsoft SQL Server, and GlueSync, demonstrating the syncing of data between the two.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-26T07:00:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-01T17:10:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image23-300x56.png\" \/>\n<meta name=\"author\" content=\"David Elliott, Solutions Engineer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Elliott, Solutions Engineer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/\"},\"author\":{\"name\":\"David Elliott, Solutions Engineer, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/83d6351038e224227bff7d6385cfc87c\"},\"headline\":\"Your Guide to Syncing Data between Couchbase and Relational Databases with GlueSync\",\"datePublished\":\"2021-10-26T07:00:16+00:00\",\"dateModified\":\"2024-03-01T17:10:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/\"},\"wordCount\":1637,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Application Design\",\"Connectors\",\"Couchbase Server\",\"Customers\",\"Solutions\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/\",\"name\":\"Sync Data Between Couchbase and Relational Databases\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2021-10-26T07:00:16+00:00\",\"dateModified\":\"2024-03-01T17:10:09+00:00\",\"description\":\"Go through the steps of how-to setup and configure Couchbase, Microsoft SQL Server, and GlueSync, demonstrating the syncing of data between the two.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Your Guide to Syncing Data between Couchbase and Relational Databases with GlueSync\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/83d6351038e224227bff7d6385cfc87c\",\"name\":\"David Elliott, Solutions Engineer, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/56b47f3906eb1da4c4bab7db411e5f42\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/david-elliott-couchbase.jpeg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/david-elliott-couchbase.jpeg\",\"caption\":\"David Elliott, Solutions Engineer, Couchbase\"},\"description\":\"Solutions Engineer at Couchbase, jack of all trades, master of some.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/pt\/author\/david-elliott\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Sync Data Between Couchbase and Relational Databases","description":"Percorra as etapas de como instalar e configurar o Couchbase, o Microsoft SQL Server e o GlueSync, demonstrando a sincroniza\u00e7\u00e3o de dados entre os dois.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/pt\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/","og_locale":"pt_BR","og_type":"article","og_title":"Your Guide to Syncing Data between Couchbase and Relational Databases with GlueSync","og_description":"Go through the steps of how-to setup and configure Couchbase, Microsoft SQL Server, and GlueSync, demonstrating the syncing of data between the two.","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/","og_site_name":"The Couchbase Blog","article_published_time":"2021-10-26T07:00:16+00:00","article_modified_time":"2024-03-01T17:10:09+00:00","og_image":[{"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/09\/image23-300x56.png","type":"","width":"","height":""}],"author":"David Elliott, Solutions Engineer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"David Elliott, Solutions Engineer","Est. reading time":"12 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/"},"author":{"name":"David Elliott, Solutions Engineer, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/83d6351038e224227bff7d6385cfc87c"},"headline":"Your Guide to Syncing Data between Couchbase and Relational Databases with GlueSync","datePublished":"2021-10-26T07:00:16+00:00","dateModified":"2024-03-01T17:10:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/"},"wordCount":1637,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Application Design","Connectors","Couchbase Server","Customers","Solutions"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/","url":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/","name":"Sync Data Between Couchbase and Relational Databases","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2021-10-26T07:00:16+00:00","dateModified":"2024-03-01T17:10:09+00:00","description":"Percorra as etapas de como instalar e configurar o Couchbase, o Microsoft SQL Server e o GlueSync, demonstrando a sincroniza\u00e7\u00e3o de dados entre os dois.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/your-guide-to-syncing-data-between-couchbase-and-relational-databases-with-gluesync\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Your Guide to Syncing Data between Couchbase and Relational Databases with GlueSync"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"Blog do Couchbase","description":"Couchbase, o banco de dados NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/83d6351038e224227bff7d6385cfc87c","name":"David Elliott, engenheiro de solu\u00e7\u00f5es, Couchbase","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/56b47f3906eb1da4c4bab7db411e5f42","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/david-elliott-couchbase.jpeg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/david-elliott-couchbase.jpeg","caption":"David Elliott, Solutions Engineer, Couchbase"},"description":"Engenheiro de solu\u00e7\u00f5es da Couchbase, especialista em todos os of\u00edcios, mestre em alguns.","url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/david-elliott\/"}]}},"authors":[{"term_id":9391,"user_id":76330,"is_guest":0,"slug":"david-elliott","display_name":"David Elliott, Solutions Engineer","avatar_url":{"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/david-elliott-couchbase.jpeg","url2x":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/09\/david-elliott-couchbase.jpeg"},"author_category":"","last_name":"Elliott, Solutions Engineer","first_name":"David","job_title":"","user_url":"","description":"Engenheiro de solu\u00e7\u00f5es da Couchbase, especialista em todos os of\u00edcios, mestre em alguns."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/11858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/76330"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=11858"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/11858\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=11858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=11858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=11858"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=11858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}