{"id":4462,"date":"2018-01-18T13:42:38","date_gmt":"2018-01-18T21:42:38","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4462"},"modified":"2023-06-13T23:54:06","modified_gmt":"2023-06-14T06:54:06","slug":"csv-migrating-couchbase-relational","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/csv-migrating-couchbase-relational\/","title":{"rendered":"Herramientas CSV para migrar a Couchbase desde una base relacional"},"content":{"rendered":"<div class=\"paragraph\">\n<p>CSV (Comma-seperated values) es un formato de archivo que se puede exportar desde una base de datos relacional (como Oracle o SQL Server). Puede ser importado a Couchbase Server con el comando <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/tools\/cbimport.html\">cbimport<\/a> utilidad.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><em>Nota: cbimport viene con Couchbase Enterprise Edition. Para Couchbase Community Edition, puede utilizar la versi\u00f3n m\u00e1s limitada <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/cli\/cbtransfer-tool.html\">cbtransfer<\/a> o utilice <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/cli\/cbdocloader-tool.html\">cbdocloader<\/a> si JSON es una opci\u00f3n.<\/em><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>Un ETL relacional\u2192CSV\u2192Couchbase directo probablemente no va a ser la soluci\u00f3n completa para la migraci\u00f3n de datos. En un post posterior, escribir\u00e9 sobre las decisiones de modelado de datos que tendr\u00e1s que considerar. Pero es un punto de partida: considera estos datos como \"por etapas\".<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><em>Nota: para este post, estoy usando SQL Server y un cluster de Couchbase Server, ambos instalados localmente. Los pasos ser\u00e1n similares para SQL Server, Oracle, MySQL, PostgreSQL, etc.<\/em><\/p>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_export_to_csv\">Exportar a CSV<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>Lo primero que hay que hacer es exportar a CSV. Tengo una base de datos relacional con dos tablas: Facturas e InvoiceItems.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/09501-relational-tables.png\" alt=\"Relational tables example\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>Voy a exportar los datos de estas dos tablas a dos archivos CSV. Con SQL Server Management Studio, esto se puede hacer de diferentes maneras. Puede utilizar <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/tools\/sqlcmd-utility\">sqlcmd<\/a> o <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/tools\/bcp-utility\">bcp<\/a> en la l\u00ednea de comandos. O puede utilizar el comando de Powershell <a href=\"https:\/\/docs.microsoft.com\/en-us\/powershell\/module\/sqlserver\/invoke-sqlcmd?view=sqlserver-ps\"><code>Invocar-Sqlcmd<\/code><\/a> y canalizarlo a trav\u00e9s de <code>Exportar-Csv<\/code>. Tambi\u00e9n puede utilizar la interfaz de usuario de SQL Server Management Studio.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/09504-export-csv-with-UI.png\" alt=\"Export CSV from SQL Server Management Studio\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>Otras bases de datos relacionales dispondr\u00e1n de utilidades de l\u00ednea de comandos, herramientas de interfaz de usuario, etc. para exportar CSV.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>A continuaci\u00f3n se muestra un ejemplo de exportaci\u00f3n a CSV de una tabla denominada \"Facturas\":<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code>Id,InvoiceNum,InvoiceDate,BillTo,ShipTo\r\n1,ABC123,2018-01-15 00:00:00.000,Lynn Hess,\"Herman Trisler, 4189 Oak Drive\"\r\n2,XYZ987,2017-06-23 00:00:00.000,Yvonne Pollak,\"Clarence Burton, 1470 Cost Avenue\"\r\n3,FOO777,2018-01-02 00:00:00.000,Phillip Freeman,\"Ronda Snell, 4685 Valley Lane\"<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>A continuaci\u00f3n se muestra una exportaci\u00f3n de una tabla relacionada denominada \"InvoiceItems\":<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code>InvoiceId,Product,Quantity,Price\r\n1,Tire,2,20.00\r\n1,Steering Wheel,5,10.00\r\n1,Engine Oil,10,15.00\r\n1,Brake Pad,24,1000.00\r\n2,Mouse pad,1,3.99\r\n2,Mouse,1,14.99\r\n2,Computer monitor,1,199.98\r\n3,Cupcake,12,.99\r\n3,Birthday candles,1,.99\r\n3,Delivery,1,30.00<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_load_csv_into_couchbase\">Cargar CSV en Couchbase<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>Vamos a importarlos a un bucket de Couchbase. Asumir\u00e9 que ya has creado un bucket vac\u00edo llamado \"staging\".<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>En primer lugar, vamos a importar invoices.csv.<\/p>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_loading_invoices\">Carga de facturas<\/h3>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-Powershell\">C:\\Program Files\\Couchbase\\Server\\bin\\cbimport csv -c localhost -u Administrator -p password -b staging -d file:\/\/invoices.csv --generate-key invoice::%Id%<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p><em>Nota: con Linux\/Mac, en lugar de <code>C:Archivos de programaCouchbase\\Server\\bin<\/code>el camino ser\u00e1 diferente.<\/em><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>Vamos a desglosarlo:<\/p>\n<\/div>\n<div class=\"ulist\">\n<ul>\n<li>\n<p><strong>cbimport<\/strong>: Esta es la utilidad de l\u00ednea de comandos que est\u00e1 utilizando<\/p>\n<\/li>\n<li>\n<p><strong>csv<\/strong>: Estamos importando desde un archivo CSV. Tambi\u00e9n puede importar desde archivos JSON.<\/p>\n<\/li>\n<li>\n<p><strong>-c localhost<\/strong>: La ubicaci\u00f3n de su cl\u00faster de Couchbase Server.<\/p>\n<\/li>\n<li>\n<p><strong>-u Administrador -p contrase\u00f1a<\/strong>: Credenciales para su cluster. Esperamos que sus credenciales sean m\u00e1s seguras que las de este ejemplo.<\/p>\n<\/li>\n<li>\n<p><strong>-b puesta en escena<\/strong>: El nombre del bucket de Couchbase en el que quieres que terminen los datos<\/p>\n<\/li>\n<li>\n<p><strong>-generar-clave-factura::%Id%<\/strong> La plantilla que se utilizar\u00e1 para crear claves \u00fanicas en Couchbase. Cada l\u00ednea del CSV corresponder\u00e1 a un \u00fanico documento. Cada documento necesita una clave \u00fanica. Decid\u00ed usar la clave primaria (entero) con un prefijo indicando que es un documento de factura.<\/p>\n<\/li>\n<\/ul>\n<\/div>\n<div class=\"paragraph\">\n<p>El resultado final de importar un archivo de 3 l\u00edneas son 3 documentos:<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/09502-csv-documents-imported-to-couchbase.png\" alt=\"CSV documents imported into Couchbase\"><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>En este punto, el cubo de puesta en escena <em>s\u00f3lo<\/em> contiene documentos de factura, por lo que es posible que desee realizar transformaciones ahora. Puede que lo haga en ejemplos de modelado posteriores, pero por ahora pasemos al siguiente archivo.<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_loading_invoice_items\">Carga de partidas de factura<\/h3>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-Powershell\">C:\\Program Files\\Couchbase\\Server\\bin\\cbimport csv -c localhost -u Administrator -p password -b staging -d file:\/\/invoice_items.csv --generate-key invoiceitem::#UUID#<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>Esto es casi id\u00e9ntico a la \u00faltima importaci\u00f3n. Una diferencia es que se trata de un nuevo fichero (invoice_items.csv). Pero la diferencia m\u00e1s importante es <strong>-generar-clave<\/strong>. Estos registros s\u00f3lo contienen claves externas, pero cada documento en Couchbase debe tener una clave \u00fanica. En \u00faltima instancia, podemos decidir <em>incrustar<\/em> estos registros en sus documentos de factura padre. Pero por ahora he decidido utilizar UUID para generar claves \u00fanicas para los registros.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>El resultado final de importar este archivo de 10 l\u00edneas son 10 documentos m\u00e1s:<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/09503-more-csv-documents-imported-to-couchbase.png\" alt=\"More CSV documents imported into Couchbase\"><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_what_s_next\">\u00bfY ahora qu\u00e9?<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>Una vez que tienes un archivo CSV, es muy f\u00e1cil introducir datos en Couchbase. Sin embargo, este tipo de traducci\u00f3n directa a menudo no va a ser suficiente por s\u00ed sola. He explorado algunos aspectos del modelado de datos en un <a href=\"https:\/\/www.couchbase.com\/blog\/es\/moving-from-sql-server-to-couchbase-part-1-data-modeling\/\">entrada anterior sobre la migraci\u00f3n desde SQL Server<\/a>pero pronto volver\u00e9 sobre este ejemplo de Facturas en una entrada de actualizaci\u00f3n del blog.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>Mientras tanto, no deje de visitar <a href=\"https:\/\/www.couchbase.com\/blog\/es\/comparing-couchbase-vs-oracle\/\">C\u00f3mo Couchbase supera a Oracle<\/a> para obtener m\u00e1s informaci\u00f3n sobre por qu\u00e9 las empresas est\u00e1n sustituyendo a Oracle para determinados casos de uso. Y tambi\u00e9n eche un vistazo al <a href=\"https:\/\/resources.couchbase.com\/c\/relational-no-sql-wp?x=Y7B0ca\">Pasar de Relational a NoSQL: C\u00f3mo empezar<\/a> libro blanco.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>Si tiene alguna pregunta o comentario, no dude en dejarlos aqu\u00ed, p\u00f3ngase en contacto conmigo en <a href=\"https:\/\/twitter.com\/mgroves\">Twitter @mgroves<\/a>o formule su pregunta en el <a href=\"https:\/\/www.couchbase.com\/blog\/es\/forums\/\">Foros de Couchbase<\/a>.<\/p>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>CSV (Comma-seperated values) is a file format that can be exported from a relational database (like Oracle or SQL Server). It can then be imported into Couchbase Server with the cbimport utility. Note: cbimport comes with Couchbase Enterprise Edition. For [&hellip;]<\/p>","protected":false},"author":71,"featured_media":4464,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816],"tags":[1614,1592,1857,1556],"ppma_author":[8937],"class_list":["post-4462","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","tag-csv","tag-oracle","tag-relational","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CSV tooling for migrating to Couchbase from Relational - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"CSV can be exported from a relational database (e.g. Oracle, SQL Server). It can then be imported into Couchbase Server with cbimport.\" \/>\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\/es\/csv-migrating-couchbase-relational\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CSV tooling for migrating to Couchbase from Relational\" \/>\n<meta property=\"og:description\" content=\"CSV can be exported from a relational database (e.g. Oracle, SQL Server). It can then be imported into Couchbase Server with cbimport.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/csv-migrating-couchbase-relational\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-18T21:42:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T06:54:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/095-hero-etl-data-migration-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"288\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Matthew Groves\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mgroves\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matthew Groves\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/\"},\"author\":{\"name\":\"Matthew Groves\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3929663e372020321b0152dc4fa65a58\"},\"headline\":\"CSV tooling for migrating to Couchbase from Relational\",\"datePublished\":\"2018-01-18T21:42:38+00:00\",\"dateModified\":\"2023-06-14T06:54:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/\"},\"wordCount\":697,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png\",\"keywords\":[\"csv\",\"oracle\",\"relational\",\"SQL Server\"],\"articleSection\":[\"Couchbase Server\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/\",\"name\":\"CSV tooling for migrating to Couchbase from Relational - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png\",\"datePublished\":\"2018-01-18T21:42:38+00:00\",\"dateModified\":\"2023-06-14T06:54:06+00:00\",\"description\":\"CSV can be exported from a relational database (e.g. Oracle, SQL Server). It can then be imported into Couchbase Server with cbimport.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png\",\"width\":1024,\"height\":288,\"caption\":\"ETL diagram by JakobVoss licensed through Creative Commons 3.0 https:\/\/commons.wikimedia.org\/wiki\/File:Etl-process.svg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CSV tooling for migrating to Couchbase from Relational\"}]},{\"@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\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/3929663e372020321b0152dc4fa65a58\",\"name\":\"Matthew Groves\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/ba51e6aacc53995c323a634e4502ef54\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g\",\"caption\":\"Matthew Groves\"},\"description\":\"Matthew D. Groves is a guy who loves to code. It doesn't matter if it's C#, jQuery, or PHP: he'll submit pull requests for anything. He has been coding professionally ever since he wrote a QuickBASIC point-of-sale app for his parent's pizza shop back in the 90s. He currently works as a Senior Product Marketing Manager for Couchbase. His free time is spent with his family, watching the Reds, and getting involved in the developer community. He is the author of AOP in .NET, Pro Microservices in .NET, a Pluralsight author, and a Microsoft MVP.\",\"sameAs\":[\"https:\/\/crosscuttingconcerns.com\",\"https:\/\/x.com\/mgroves\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/es\/author\/matthew-groves\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"CSV tooling for migrating to Couchbase from Relational - The Couchbase Blog","description":"CSV se puede exportar desde una base de datos relacional (por ejemplo, Oracle, SQL Server). A continuaci\u00f3n, se puede importar en Couchbase Server con cbimport.","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\/es\/csv-migrating-couchbase-relational\/","og_locale":"es_MX","og_type":"article","og_title":"CSV tooling for migrating to Couchbase from Relational","og_description":"CSV can be exported from a relational database (e.g. Oracle, SQL Server). It can then be imported into Couchbase Server with cbimport.","og_url":"https:\/\/www.couchbase.com\/blog\/es\/csv-migrating-couchbase-relational\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-01-18T21:42:38+00:00","article_modified_time":"2023-06-14T06:54:06+00:00","og_image":[{"width":1024,"height":288,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/095-hero-etl-data-migration-1.png","type":"image\/png"}],"author":"Matthew Groves","twitter_card":"summary_large_image","twitter_creator":"@mgroves","twitter_misc":{"Written by":"Matthew Groves","Est. reading time":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/"},"author":{"name":"Matthew Groves","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3929663e372020321b0152dc4fa65a58"},"headline":"CSV tooling for migrating to Couchbase from Relational","datePublished":"2018-01-18T21:42:38+00:00","dateModified":"2023-06-14T06:54:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/"},"wordCount":697,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png","keywords":["csv","oracle","relational","SQL Server"],"articleSection":["Couchbase Server"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/","url":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/","name":"CSV tooling for migrating to Couchbase from Relational - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png","datePublished":"2018-01-18T21:42:38+00:00","dateModified":"2023-06-14T06:54:06+00:00","description":"CSV se puede exportar desde una base de datos relacional (por ejemplo, Oracle, SQL Server). A continuaci\u00f3n, se puede importar en Couchbase Server con cbimport.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/01\/095-hero-etl-data-migration-1.png","width":1024,"height":288,"caption":"ETL diagram by JakobVoss licensed through Creative Commons 3.0 https:\/\/commons.wikimedia.org\/wiki\/File:Etl-process.svg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/csv-migrating-couchbase-relational\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CSV tooling for migrating to Couchbase from Relational"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos 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":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@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\/3929663e372020321b0152dc4fa65a58","name":"Matthew Groves","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/ba51e6aacc53995c323a634e4502ef54","url":"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g","caption":"Matthew Groves"},"description":"A Matthew D. Groves le encanta programar. No importa si se trata de C#, jQuery o PHP: enviar\u00e1 pull requests para cualquier cosa. Lleva codificando profesionalmente desde que escribi\u00f3 una aplicaci\u00f3n de punto de venta en QuickBASIC para la pizzer\u00eda de sus padres, all\u00e1 por los a\u00f1os noventa. Actualmente trabaja como Director de Marketing de Producto para Couchbase. Su tiempo libre lo pasa con su familia, viendo a los Reds y participando en la comunidad de desarrolladores. Es autor de AOP in .NET, Pro Microservices in .NET, autor de Pluralsight y MVP de Microsoft.","sameAs":["https:\/\/crosscuttingconcerns.com","https:\/\/x.com\/mgroves"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/matthew-groves\/"}]}},"authors":[{"term_id":8937,"user_id":71,"is_guest":0,"slug":"matthew-groves","display_name":"Matthew Groves","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g","author_category":"","last_name":"Groves","first_name":"Matthew","job_title":"","user_url":"https:\/\/crosscuttingconcerns.com","description":"A Matthew D. Groves le encanta programar.  No importa si se trata de C#, jQuery o PHP: enviar\u00e1 pull requests para cualquier cosa.  Lleva codificando profesionalmente desde que escribi\u00f3 una aplicaci\u00f3n de punto de venta en QuickBASIC para la pizzer\u00eda de sus padres, all\u00e1 por los a\u00f1os noventa.  Actualmente trabaja como Director de Marketing de Producto para Couchbase. Su tiempo libre lo pasa con su familia, viendo a los Reds y participando en la comunidad de desarrolladores.  Es autor de AOP in .NET, Pro Microservices in .NET, autor de Pluralsight y MVP de Microsoft."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/4462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/71"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=4462"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/4462\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/4464"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=4462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=4462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=4462"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=4462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}