{"id":1794,"date":"2013-07-08T10:00:00","date_gmt":"2013-07-08T08:00:00","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=1794"},"modified":"2017-03-01T07:39:01","modified_gmt":"2017-03-01T15:39:01","slug":"sql-nosql-copy-your-data-mysql-couchbase","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/sql-nosql-copy-your-data-mysql-couchbase\/","title":{"rendered":"SQL to NoSQL : Copia tus datos de MySQL a Couchbase"},"content":{"rendered":"<p style=\"margin-bottom: 0px; font-family: ff-kievit-web, 'MS UI Gothic', 'MS PGothic', Osaka, Batang, Georgia, 'Times New Roman', Times, sans-serif; font-size: 16px;\"><em style=\"line-height: 23px; font-size: 1em; font-family: ff-meta-serif-web-pro-1, ff-meta-serif-web-pro-2, Georgia, 'Times New Roman', Times, serif;\">[This blog was syndicated from https:\/\/blog.grallandco.com]<\/em><\/p>\n<div><\/div>\n<div>\n<h2><span style=\"line-height: 1;\">Introducci\u00f3n<\/span><\/h2>\n<div>Durante mis \u00faltimas interacciones con la comunidad de Couchbase, me surgi\u00f3 la pregunta de c\u00f3mo puedo importar f\u00e1cilmente mis datos de mi base de datos actual a Couchbase. Y mi respuesta era siempre la misma:<\/div>\n<ul>\n<li>Utilice un ETL como Talend para hacerlo<\/li>\n<li><span style=\"line-height: 1;\">S\u00f3lo tienes que escribir un peque\u00f1o programa para copiar los datos de tu RDBMS a Couchbase...<\/span><\/li>\n<\/ul>\n<div>As\u00ed que he escrito este peque\u00f1o programa que te permite importar el contenido de un RDBMS a Couchbase. Esta herramienta se puede usar tal cual, o puedes mirar el c\u00f3digo para adaptarlo a tu aplicaci\u00f3n.<\/div>\n<\/div>\n<div><\/div>\n<div>\n<div><a href=\"https:\/\/www.youtube.com\/watch?v=xzqBjhYKCLY\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2885 size-full aligncenter\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2013\/07\/couchbase-sql-importer-video-thumbnail.jpg\" alt=\"couchbase-sql-importer-video-thumbnail\" width=\"351\" height=\"198\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2013\/07\/couchbase-sql-importer-video-thumbnail.jpg 351w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2013\/07\/couchbase-sql-importer-video-thumbnail-300x169.jpg 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2013\/07\/couchbase-sql-importer-video-thumbnail-20x11.jpg 20w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/a><\/div>\n<div><\/div>\n<h2>La herramienta: Importador SQL de Couchbase<\/h2>\n<div>El importador SQL de Couchbase, disponible <a href=\"https:\/\/github.com\/tgrall\/couchbase-sql-importer\">aqu\u00ed<\/a>te permite con una simple l\u00ednea de comandos copiar todo -o parte- de tu esquema SQL en Couchbase. Antes de explicar c\u00f3mo ejecutar este comando, veamos c\u00f3mo se almacenan los datos en Couchbase cuando se importan:<\/div>\n<ul>\n<li><span style=\"line-height: 1;\">Cada fila de la tabla se importa en un \u00fanico documento JSON<\/span>\n<ul>\n<li>donde cada columna de la tabla se convierte en un atributo JSON<\/li>\n<\/ul>\n<\/li>\n<li>Cada documento como una clave formada por el nombre de la tabla y un contador (incremento)<\/li>\n<\/ul>\n<div>El siguiente ejemplo concreto, basado en el <a href=\"https:\/\/dev.mysql.com\/doc\/world-setup\/en\/index.html\">Base de datos de ejemplo MySQL World<\/a>le ayudar\u00e1 a comprender su funcionamiento. Esta base de datos contiene 3 tablas : Ciudad, Pa\u00eds, Pa\u00edsIdioma. La tabla Ciudad tiene el siguiente aspecto:<\/div>\n<blockquote>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">+&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8211;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| Campo Tipo Nulo Clave Predeterminado Extra<br \/>\n+&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8211;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| ID | int(11) | NO | PRI | NULL | auto_increment |<br \/>\n| Nombre | char(35) | NO | | | | |<br \/>\n| CountryCode | char(3) | NO | | | | |<br \/>\n| Distrito | char(20) | NO | | | | |<br \/>\n| Poblaci\u00f3n | int(11) | NO | | 0 | |<br \/>\n+&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8212;+&#8212;&#8211;+&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;-+<\/div>\n<\/div>\n<\/blockquote>\n<div>El documento JSON que corresponde a esta tabla tiene el siguiente aspecto:<\/div>\n<div>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">ciudad:3805<br \/>\n{<br \/>\n\"Nombre\": \"San Francisco\",<br \/>\n\"Distrito\": \"California\",<br \/>\n\"ID\": 3805,<br \/>\n\"Poblaci\u00f3n\": 776733,<br \/>\n\"CountryCode\": \"USA\"<br \/>\n}<\/div>\n<\/div>\n<\/div>\n<div>Ves que aqu\u00ed simplemente estoy cogiendo todas las filas y \"movi\u00e9ndolas\" a Couchbase. Este es un buen primer paso para jugar con tu conjunto de datos en Couchbase, pero probablemente no es el modelo final que quieres usar para tu aplicaci\u00f3n; la mayor\u00eda de las veces tendr\u00e1s que ver cuando usar documentos incrustados, lista de valores, .. en tus documentos JSON.<\/div>\n<div>Adem\u00e1s del documento JSON, la herramienta crea vistas basadas en la siguiente l\u00f3gica:<\/div>\n<ul>\n<li>una vista que enumera todos los documentos importados con el nombre de la \"tabla\" (alias tipo) como clave<\/li>\n<li>una vista para cada tabla con las columnas de clave primaria<\/li>\n<\/ul>\n<div>Vista: todos\/por_tipo<\/div>\n<div>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">{<br \/>\n\"filas\": [<br \/>\n{\"clave\": \"ciudad\", \"valor\": 4079},<br \/>\n{\"clave\": \"pa\u00eds\", \"valor\": 239},<br \/>\n{\"clave\": \"countrylanguage\", \"value\": 984}<br \/>\n]<br \/>\n}<\/div>\n<\/div>\n<\/div>\n<div>Como puedes ver esta vista te permite obtener con una sola consulta a Couchbase el n\u00famero de documentos por tipo.<\/div>\n<div>Tambi\u00e9n para cada tipo de tabla\/documento, se crea una vista donde la clave del \u00edndice se construye a partir de la clave primaria de la tabla. Por ejemplo, consultemos los documentos \"Ciudad\".<\/div>\n<div>Ver: ciudad\/por_pk?reduce=false&amp;limit=5<\/div>\n<div>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">{<br \/>\n\"total_rows\": 4079,<br \/>\n\"filas\": [<br \/>\n{\"id\": \"ciudad:1\", \"clave\": 1, \"valor\": null},<br \/>\n{\"id\": \"ciudad:2\", \"clave\": 2, \"valor\": null},<br \/>\n{\"id\": \"ciudad:3\", \"clave\": 3, \"valor\": null},<br \/>\n{\"id\": \"ciudad:4\", \"clave\": 4, \"valor\": null},<br \/>\n{\"id\": \"ciudad:5\", \"clave\": 5, \"valor\": null}<br \/>\n]<br \/>\n}<\/div>\n<\/div>\n<\/div>\n<div>La clave de \u00edndice coincide con el valor de la columna Ciudad.ID.  Cuando la clave primaria se compone de varias columnas, la clave tiene el siguiente aspecto:<\/div>\n<div>Ver: CountryLanguage\/by_pk?reduce=false&amp;limit=5<\/div>\n<div>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">{<br \/>\n\"total_rows\": 984,<br \/>\n\"filas\": [<br \/>\n{\"id\": \"countrylanguage:1\", \"key\": [\"ABW\", \"Dutch\"], \"value\": null},<br \/>\n{\"id\": \"countrylanguage:2\", \"key\": [\"ABW\", \"English\"], \"value\": null},<br \/>\n{\"id\": \"countrylanguage:3\", \"key\": [\"ABW\", \"Papiamento\"], \"value\": null},<br \/>\n{\"id\": \"countrylanguage:4\", \"key\": [\"ABW\", \"Espa\u00f1ol\"], \"valor\": null},<br \/>\n{\"id\": \"countrylanguage:5\", \"key\": [\"AFG\", \"Balochi\"], \"value\": null}<br \/>\n]<br \/>\n}<\/div>\n<\/div>\n<\/div>\n<div>Esta vista se construye a partir de la clave primaria de la tabla CountryLanguage formada por las columnas CountryLanguage.CountryCode y CountryLanguage.Language.<\/div>\n<div>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">+&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8211;+&#8212;&#8212;&#8212;+&#8212;&#8212;-+<br \/>\n| Campo Tipo Nulo Clave Predeterminado Extra<br \/>\n+&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8211;+&#8212;&#8212;&#8212;+&#8212;&#8212;-+<br \/>\n| CountryCode | char(3) | NO | PRI | | | |<br \/>\n| Idioma | char(30) | NO | PRI | | |<br \/>\n| IsOfficial | enum('T','F') | NO | | F | |<br \/>\n| Porcentaje | float(4,1) | NO | | 0.0 | |<br \/>\n+&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;+&#8212;&#8211;+&#8212;&#8212;&#8212;+&#8212;&#8212;-+<\/div>\n<\/div>\n<\/div>\n<div><strong>\u00bfC\u00f3mo utilizar la herramienta Couchbase SQL Importer?\u00a0<\/strong><\/div>\n<div>El importador es una sencilla utilidad de l\u00ednea de comandos basada en Java, bastante f\u00e1cil de usar:<\/div>\n<div>1. Descargue el <a href=\"https:\/\/goo.gl\/IF89e\">CouchbaseSqlImporter.jar desde aqu\u00ed<\/a>. Este archivo contiene todas las dependencias para trabajar con Couchbase: el cliente Java Couchbase y GSON.<\/div>\n<div>2. Descargue el controlador JDBC para la base de datos que est\u00e1 utilizando como fuente de datos. Para este ejemplo estoy usando MySQL y he descargado el driver para MySQL Site.<\/div>\n<div>3. Configure la importaci\u00f3n mediante un archivo de propiedades.<\/div>\n<div>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">## Informaci\u00f3n SQL ##<br \/>\nsql.connection=jdbc:mysql:\/\/192.168.99.19:3306\/world<br \/>\nsql.nombreusuario=root<br \/>\nsql.password=contrase\u00f1a## Informaci\u00f3n de Couchbase ##<br \/>\ncb.uris=https:\/\/localhost:8091\/pools<br \/>\ncb.bucket=pordefecto<br \/>\ncb.password=## Informaci\u00f3n de importaci\u00f3n<br \/>\nimportar.tablas=ALL<br \/>\nimport.createViews=true<br \/>\nimport.typefield=tipo<br \/>\nimport.fieldcase=lower<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div>Este archivo de propiedades de ejemplo contiene tres secciones :<\/div>\n<ul>\n<li>Las dos primeras secciones se utilizan para configurar las conexiones a su base de datos SQL y al cl\u00faster Couchbase (tenga en cuenta que primero debe crearse el bucket)<\/li>\n<li>La tercera secci\u00f3n permite configurar la propia importaci\u00f3n\n<ul>\n<li><span style=\"font-family: 'Courier New', Courier, monospace;\">importar.tablas<\/span>\u00a0: ALL para importar todas las tablas, o una la lista de tablas que desea importar, por ejemplo Ciudad, Pa\u00eds<\/li>\n<li><span style=\"font-family: 'Courier New', Courier, monospace;\">import.createViews<\/span>\u00a0: verdadero o falso, para forzar la creaci\u00f3n de las vistas.<\/li>\n<li><span style=\"font-family: 'Courier New', Courier, monospace;\">campo.tipo.import<\/span>\u00a0: se utiliza para a\u00f1adir un nuevo atributo en todos los documentos que contengan el \"tipo\".<\/li>\n<li><span style=\"font-family: 'Courier New', Courier, monospace;\">import.fieldcase<\/span>\u00a0: null, lower, upper : esto forzar\u00e1 el caso del nombre de los atributos y el valor del tipo (Ciudad o city o CITY por ejemplo)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><span style=\"line-height: 1;\">4. Ejecute la herramienta.<\/span><\/li>\n<\/ul>\n<div>\n<div class=\"geshifilter\">\n<div class=\"text geshifilter-text\" style=\"font-family: monospace;\">java -cp \".\/CouchbaseSqlImporter.jar:.\/mysql-connector-java-5.1.25-bin.jar\" com.couchbase.util.SqlImporter import.properties<\/div>\n<\/div>\n<\/div>\n<div>As\u00ed que ejecuta el comando Java con el classpath adecuado (par\u00e1metro -cp).<\/div>\n<div>Y ya est\u00e1, puedes obtener tus datos de tu base de datos SQL en Couchbase.<\/div>\n<div>Si est\u00e1 interesado en ver c\u00f3mo funciona internamente, puede echar un vistazo al siguiente p\u00e1rrafo.<\/div>\n<h2>El C\u00f3digo: \u00bfC\u00f3mo funciona?<\/h2>\n<div>La clase principal de la herramienta es realmente sencilla \u00a0<a href=\"https:\/\/github.com\/tgrall\/couchbase-sql-importer\/blob\/master\/sql-importer-lib\/src\/main\/java\/com\/couchbase\/util\/SqlImporter.java\">com.couchbase.util.SqlImporter<\/a>el proceso es:<\/div>\n<div>1. Conectarse a la base de datos SQL<\/div>\n<div>2. Conectar a Couchbase<\/div>\n<div>3. Obtener la lista de tablas<\/div>\n<div>4. Para cada tabla ejecute un \"select * from table\"<\/div>\n<div>\u00a0 4.1. Analizar el ResultSetMetadata para obtener la lista de columnas<\/div>\n<div>\u00a0 4.2. Crear un mapa Java para cada fila donde la clave es el nombre de las columnas y el valor...es el valor<\/div>\n<div>\u00a0 4.3. Serializa este Mapa en un documento GSON y gu\u00e1rdalo en Couchbase<\/div>\n<div>El c\u00f3digo est\u00e1 disponible en <a href=\"https:\/\/github.com\/tgrall\/couchbase-sql-importer\/blob\/master\/sql-importer-lib\/src\/main\/java\/com\/couchbase\/util\/SqlImporter.java#L212\">ImportTable(String table)<\/a> M\u00e9todo Java.<\/div>\n<div>Un punto interesante es que puedes utilizar y ampliar el c\u00f3digo para adaptarlo a tu aplicaci\u00f3n.<\/div>\n<h2>Conclusi\u00f3n<\/h2>\n<div>He creado esta herramienta r\u00e1pidamente para ayudar a algunas personas en la comunidad, si usted lo est\u00e1 utilizando y necesita nuevas caracter\u00edsticas, h\u00e1gamelo saber, mediante comentario o pull request.<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[This blog was syndicated from https:\/\/blog.grallandco.com] Introduction During my last interactions with the Couchbase community, I had the question how can I easily import my data from my current database into Couchbase. And my answer was always the same: Take [&hellip;]<\/p>","protected":false},"author":2,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"ppma_author":[8968],"class_list":["post-1794","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"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>SQL to NoSQL : Copy your data from MySQL to Couchbase - The Couchbase Blog<\/title>\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\/sql-nosql-copy-your-data-mysql-couchbase\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL to NoSQL : Copy your data from MySQL to Couchbase\" \/>\n<meta property=\"og:description\" content=\"[This blog was syndicated from https:\/\/blog.grallandco.com] Introduction During my last interactions with the Couchbase community, I had the question how can I easily import my data from my current database into Couchbase. And my answer was always the same: Take [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/sql-nosql-copy-your-data-mysql-couchbase\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-08T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-03-01T15:39:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2022\/11\/couchbase-nosql-dbaas.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"The Couchbase Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Couchbase Team\" \/>\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\/sql-nosql-copy-your-data-mysql-couchbase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/\"},\"author\":{\"name\":\"The Couchbase Team\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/764f4a6771ee19bc7af70b70a326fb93\"},\"headline\":\"SQL to NoSQL : Copy your data from MySQL to Couchbase\",\"datePublished\":\"2013-07-08T08:00:00+00:00\",\"dateModified\":\"2017-03-01T15:39:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/\"},\"wordCount\":1077,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/\",\"name\":\"SQL to NoSQL : Copy your data from MySQL to Couchbase - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2013-07-08T08:00:00+00:00\",\"dateModified\":\"2017-03-01T15:39:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#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\/sql-nosql-copy-your-data-mysql-couchbase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL to NoSQL : Copy your data from MySQL to Couchbase\"}]},{\"@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\/764f4a6771ee19bc7af70b70a326fb93\",\"name\":\"The Couchbase Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/7befc37d02226b59499817eafdec60c3\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g\",\"caption\":\"The Couchbase Team\"},\"description\":\"Jennifer Garcia is a Senior Web Manager at Couchbase Inc. As the website manager, Jennifer has overall responsibility for the website properties including design, implementation, content, and performance.\",\"sameAs\":[\"https:\/\/www.couchbase.com\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/es\/author\/jennifer-garcia\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL to NoSQL : Copy your data from MySQL to Couchbase - The Couchbase Blog","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\/sql-nosql-copy-your-data-mysql-couchbase\/","og_locale":"es_MX","og_type":"article","og_title":"SQL to NoSQL : Copy your data from MySQL to Couchbase","og_description":"[This blog was syndicated from https:\/\/blog.grallandco.com] Introduction During my last interactions with the Couchbase community, I had the question how can I easily import my data from my current database into Couchbase. And my answer was always the same: Take [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/es\/sql-nosql-copy-your-data-mysql-couchbase\/","og_site_name":"The Couchbase Blog","article_published_time":"2013-07-08T08:00:00+00:00","article_modified_time":"2017-03-01T15:39:01+00:00","og_image":[{"width":1800,"height":630,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2022\/11\/couchbase-nosql-dbaas.png","type":"image\/png"}],"author":"The Couchbase Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Couchbase Team","Est. reading time":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/"},"author":{"name":"The Couchbase Team","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/764f4a6771ee19bc7af70b70a326fb93"},"headline":"SQL to NoSQL : Copy your data from MySQL to Couchbase","datePublished":"2013-07-08T08:00:00+00:00","dateModified":"2017-03-01T15:39:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/"},"wordCount":1077,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Uncategorized"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/","url":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/","name":"SQL to NoSQL : Copy your data from MySQL to Couchbase - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2013-07-08T08:00:00+00:00","dateModified":"2017-03-01T15:39:01+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/sql-nosql-copy-your-data-mysql-couchbase\/#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\/sql-nosql-copy-your-data-mysql-couchbase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL to NoSQL : Copy your data from MySQL to Couchbase"}]},{"@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\/764f4a6771ee19bc7af70b70a326fb93","name":"El equipo de Couchbase","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/7befc37d02226b59499817eafdec60c3","url":"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g","caption":"The Couchbase Team"},"description":"Jennifer Garcia es Gerente Senior de Web en Couchbase Inc. Como responsable del sitio web, Jennifer tiene la responsabilidad general de las propiedades del sitio web, incluido el dise\u00f1o, la implementaci\u00f3n, el contenido y el rendimiento.","sameAs":["https:\/\/www.couchbase.com"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/jennifer-garcia\/"}]}},"authors":[{"term_id":8968,"user_id":2,"is_guest":0,"slug":"jennifer-garcia","display_name":"The Couchbase Team","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g","author_category":"","last_name":"Garcia","first_name":"Jennifer","job_title":"","user_url":"https:\/\/www.couchbase.com","description":"Jennifer Garcia es Gerente Senior de Web en Couchbase Inc. Como responsable del sitio web, Jennifer tiene la responsabilidad general de las propiedades del sitio web, incluido el dise\u00f1o, la implementaci\u00f3n, el contenido y el rendimiento."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/1794","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=1794"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/1794\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=1794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=1794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=1794"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=1794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}