{"id":7135,"date":"2024-01-29T11:43:46","date_gmt":"2024-01-29T02:43:46","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=7135"},"modified":"2024-02-16T15:53:04","modified_gmt":"2024-02-16T06:53:04","slug":"gluesync%e3%81%a7nosql%e6%b4%bb%e7%94%a8%e3%82%92%e5%8a%a0%e9%80%9f%ef%bc%9a%e5%b0%8e%e5%85%a5%e7%b7%a8","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7135","title":{"rendered":"GlueSync\u3067NoSQL\u6d3b\u7528\u3092\u52a0\u901f\uff1a\u5c0e\u5165\u7de8"},"content":{"rendered":"\n<p>GlueSync\u306f\u30c7\u30fc\u30bf\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001\u65e2\u5b58\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3068\u5927\u304d\u304f\u7570\u306a\u308a\u3001\u4ee5\u4e0b\u306e\u70b9\u306b\u7279\u5316\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3067\u30b9\u30c6\u30fc\u30c8\u30ec\u30b9\u306a\u30b3\u30f3\u30c6\u30ca\u3068\u3057\u3066\u52d5\u4f5c<\/li><li>NoSQL\u3084\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u3078\u306e\u30c7\u30fc\u30bf\u9023\u643a<\/li><\/ul>\n\n\n\n<p>\u30b3\u30f3\u30c6\u30ca\u3067\u52d5\u4f5c\u3057\u3001Docker\u3084Kubernetes\u74b0\u5883\u3067\u7c21\u5358\u306b\u5b9f\u884c\u3067\u304d\u308b\u3068\u3044\u3046\u70b9\u3067\u5b9f\u88c5\u3092\u5bb9\u6613\u306b\u3057\u3064\u3064\u3001RDBMS\u4e0a\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3069\u306e\u3088\u3046\u306bNoSQL\u4e0a\u306eJSON\u5f62\u5f0f\u306b\u843d\u3068\u3057\u8fbc\u3093\u3067\u3044\u304f\u304b\u3068\u3044\u3063\u305f\u70b9\u306b\u67d4\u8edf\u306b\u5bfe\u5fdc\u3057\u305f\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u5b9f\u969b\u306b\u3053\u306eGlueSync\u3092Docker\u74b0\u5883\u3067\u5b9f\u884c\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>\u307e\u305a\u3001Docker\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u95a2\u3057\u3066\u3067\u3059\u304c\u3001\u7279\u5225\u306a\u69cb\u6210\u306f\u4e0d\u8981\u3067\u3059\u3002\u516c\u5f0f\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u3042\u308b\u624b\u9806\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3044\u305f\u3060\u3051\u308c\u3070\u554f\u984c\u306a\u304f\u3054\u5229\u7528\u3044\u305f\u3060\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.docker.com\/engine\/install\/\">https:\/\/docs.docker.com\/engine\/install\/<\/a><\/p>\n\n\n\n<p>\u305d\u306e\u5f8c\u3001\u30a4\u30e1\u30fc\u30b8\u3092\u4f5c\u6210\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u3053\u308c\u306b\u95a2\u3057\u3066\u3082\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u958b\u767a\u5143\u306e\u30ec\u30b8\u30b9\u30c8\u30ea\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304f\u308b\u3060\u3051\u3067\u3059\u306e\u3067\u3001\u96e3\u3057\u3044\u3053\u3068\u306f\u7279\u306b\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u8a55\u4fa1\u3084\u88fd\u54c1\u3054\u8cfc\u5165\u3044\u305f\u3060\u3044\u305f\u969b\u306b\u306f\u30ec\u30b8\u30b9\u30c8\u30ea\u30a2\u30af\u30bb\u30b9\u306e\u305f\u3081\u306e\u8a8d\u8a3c\u60c5\u5831\u304c\u958b\u767a\u5143\u304b\u3089\u63d0\u4f9b\u3055\u308c\u307e\u3059\u306e\u3067\u3001\u305d\u308c\u3067\u3001\u30ed\u30b0\u30a4\u30f3\u3044\u305f\u3060\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ docker login -u molo17com\nPassword: \nWARNING! Your password will be stored unencrypted in \/home\/climb\/.docker\/config.json.\nConfigure a credential helper to remove this warning. See\nhttps:&#47;&#47;docs.docker.com\/engine\/reference\/commandline\/login\/#credentials-store\n\nLogin Succeeded<\/code><\/pre>\n\n\n\n<p>\u4f7f\u7528\u3059\u308b\u30a4\u30e1\u30fc\u30b8\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\/NoSQL\u306e\u7d44\u307f\u5408\u308f\u305b\u3084\u5909\u66f4\u8ffd\u8de1\u65b9\u6cd5\u3067\u3053\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u74b0\u5883\u306b\u3042\u308f\u305b\u3066\u9078\u629e\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306fMicrosoft SQL Server\u304b\u3089Couchbase\u3078\u306e\u30ec\u30d7\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u69cb\u6210\u3057\u3066\u3044\u304d\u307e\u3059\u306e\u3067\u3001\u305d\u308c\u306b\u3042\u308f\u305b\u305f\u30a4\u30e1\u30fc\u30b8\u3092\u6307\u5b9a\u3057\u3066docker-compose.yml\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># docker-compose.yml\nversion: '3.7'\n\nservices:\n  gluesync-s2n:\n    image: molo17com\/gluesync-sql-to-nosql:mssql-to-couchbase-1.5.29\n    restart: 'no'\n    environment:\n      - CONFIG_FILE=\/opt\/app\/config\/config.json\n      - LICENCE_KEY=\/opt\/app\/config\/gs-licence.dat\n    volumes:\n      - \"$PWD\/config:\/opt\/app\/config\"<\/code><\/pre>\n\n\n\n<p>\u30a4\u30e1\u30fc\u30b8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>climb@gs-forblog:~$ docker compose create\n&#91;+] Running 6\/6\n &#x2714; gluesync-s2n 5 layers &#91;\u28ff\u28ff\u28ff\u28ff\u28ff]    0B\/0B    Pulled    21.8s \n   &#x2714; 3dd181f9be59 Pull complete                          2.2s \n   &#x2714; daaba932f0b8 Pull complete                          13.3s \n   &#x2714; a7d194dba5db Pull complete                          1.0s \n   &#x2714; 97ae4decef80 Pull complete                          11.5s \n   &#x2714; 4f4fb700ef54 Pull complete                          2.8s \n&#91;+] Creating 1\/1\n &#x2714; Container climb-gluesync-s2n-1  Created  <\/code><\/pre>\n\n\n\n<p>\u6b21\u306b\u3001docker-compose.yml\u3067\u6307\u5b9a\u3057\u3066\u3044\u308b\u30e9\u30a4\u30bb\u30f3\u30b9\u30d5\u30a1\u30a4\u30ebgs-licence.dat\u3092\u914d\u7f6e\u3057\u307e\u3059\u3002\u3053\u3061\u3089\u3082\u8a55\u4fa1\u3001\u88fd\u54c1\u3054\u8cfc\u5165\u6642\u306b\u958b\u767a\u5143\u304b\u3089\u63d0\u4f9b\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>climb@gs-forblog:~$ ls config\/\ngs-licence.dat<\/code><\/pre>\n\n\n\n<p>\u305d\u3057\u3066\u8a2d\u5b9a\u3092config.json\u3067\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n    \"sourceHost\": \"192.168.33.15\",\n    \"sourcePort\": \"1433\",\n    \"sourceName\": \"demo\",\n    \"sourceUsername\": \"gs-user\",\n    \"sourcePassword\": \"P@ssword123\",\n    \"mssql\": {\n      \"temporaryTableNamePrefix\": \"gs\",\n      \"statePreservationTableNamePrefix\": \"gs\"\n    },\n\n    \"targetHost\": \"192.168.33.15\",\n    \"targetPort\": \"8091\",\n    \"targetName\": \"demo\",\n    \"targetUsername\": \"gs-user\",\n    \"targetPassword\": \"password\",\n    \"couchbase\": {\n      \"useCollections\": true\n    },\n\n    \"sourceEntities\": {\n      \"tableSync\": {\n        \"schema\": \"dbo\",\n        \"table\": \"DRIVERS\",\n        \"type\": \"drivers\",\n        \"scope\": \"data\"\n      }\n    },\n\n    \"sourceChangeRetention\": 5,\n    \"copySourceEntitiesAtStartup\": true,\n    \"maxItemsCountPerTransaction\": 100,\n    \"maxMigrationItemsCountPerIteration\": 20000\n  }<\/code><\/pre>\n\n\n\n<p>\u30bd\u30fc\u30b9\u63a5\u7d9a\u306b\u95a2\u3059\u308b\u8a2d\u5b9a<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>sourceHost &#8211; \u63a5\u7d9a\u5148\u3068\u306a\u308bSQL Server\u306eIP\u30a2\u30c9\u30ec\u30b9\u307e\u305f\u306fDNS\u540d<\/li><li>sourcePort &#8211; \u63a5\u7d9a\u5148\u3068\u306a\u308bSQL Server\u306e\u30dd\u30fc\u30c8<\/li><li>sourceName &#8211; \u63a5\u7d9a\u5148\u3068\u306a\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d<\/li><li>sourceUsername &#8211; \u7279\u6a29\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6\u540d<\/li><li>sourcePassword &#8211; \u7279\u6a29\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\" id=\"block-30d568a3-ec9f-464b-b374-953361359ffb\"><li>mssql &#8211; SQL Server\u306b\u95a2\u3059\u308b\u56fa\u6709\u306e\u8a2d\u5b9a<ul><li>temporaryTableNamePrefix &#8211; (\u30aa\u30d7\u30b7\u30e7\u30f3) \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5411\u4e0a\u3055\u305b\u308b\u305f\u3081\u306b\u3001Gluesync \u306b\u3088\u3063\u3066\u4f5c\u6210\u3055\u308c\u308b\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30b9\u30bf\u30e0 \u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<br>\u4e00\u822c\u7684\u306a\u4f7f\u7528\u4f8b\u306f\u3001\u8907\u6570\u306eGluesync\u3067\u540c\u3058\u30bd\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u969b\u306b\u7af6\u5408\u3092\u56de\u907f\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/li><li>statePreservationTableNamePrefix &#8211; (\u30aa\u30d7\u30b7\u30e7\u30f3) \u51e6\u7406\u3055\u308c\u305f\u5909\u66f4\u306e\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u3092\u4fdd\u6301\u3059\u308b\u305f\u3081\u306b\u3001Gluesync \u306b\u3088\u3063\u3066\u4f5c\u6210\u3055\u308c\u308b\u72b6\u614b\u4fdd\u5b58\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30b9\u30bf\u30e0 \u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<br>\u4e00\u822c\u7684\u306a\u4f7f\u7528\u4f8b\u306f\u3001\u8907\u6570\u3000\u306eGluesync\u3067\u540c\u3058\u30bd\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u969b\u306b\u7af6\u5408\u3092\u56de\u907f\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/li><\/ul><\/li><\/ul>\n\n\n\n<p>\u30bf\u30fc\u30b2\u30c3\u30c8\u63a5\u7d9a\u306b\u95a2\u3059\u308b\u8a2d\u5b9a<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>targetHost &#8211; \u63a5\u7d9a\u5148\u3068\u306a\u308bcouchbase\u306eIP\u30a2\u30c9\u30ec\u30b9\u307e\u305f\u306fDNS\u540d<\/li><li>targetPort &#8211; \u63a5\u7d9a\u5148\u3068\u306a\u308bcouchbase\u306e\u30dd\u30fc\u30c8<\/li><li>targetName &#8211; \u63a5\u7d9a\u5148\u3068\u306a\u308b\u30d0\u30b1\u30c3\u30c8\u540d<\/li><li>targetUsername &#8211;  \u7279\u6a29\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6\u540d<\/li><li>targetPassword &#8211; \u7279\u6a29\u30e6\u30fc\u30b6\u306e\u30d1\u30b9\u30ef\u30fc\u30c9<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>couchbase &#8211; couchbase\u306b\u95a2\u3059\u308b\u56fa\u6709\u306e\u8a2d\u5b9a<ul><li>certificatesPath &#8211;  (\u30aa\u30d7\u30b7\u30e7\u30f3) HTTPS\u3067\u306e\u901a\u4fe1\u6642\u306b\u3001Couchbase Server\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u3068\u304d\u306b\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u8a3c\u660e\u66f8\u3078\u306e\u30d1\u30b9\u3002\u7701\u7565\u3057\u305f\u5834\u5408\u3001\u8a3c\u660e\u66f8\u306f\u4f7f\u7528\u3055\u308c\u307e\u305b\u3093\u3002<\/li><li>timeoutSeconds &#8211;  (\u30aa\u30d7\u30b7\u30e7\u30f3) Couchbase \u30b5\u30fc\u30d0\u3068\u306e\u901a\u4fe1\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u3068\u3057\u3066\u8a2d\u5b9a\uff08\u79d2\uff09<\/li><li>indexReplicaCount &#8211;  (\u30aa\u30d7\u30b7\u30e7\u30f3) Gluesync \u306b\u3088\u3063\u3066\u751f\u6210\u3055\u308c\u308b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9 \u30ec\u30d7\u30ea\u30ab\u306e\u6570\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<em>\u305d\u306e\u6570\u5024\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30ce\u30fc\u30c9\u6570\u20151<\/em>\u3068\u3057\u3066\u8a08\u7b97\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u30013 \u30ce\u30fc\u30c9 \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5834\u5408\u30012\u3092\u30ec\u30d7\u30ea\u30ab\u3068\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u63a8\u5968\u3055\u308c\u307e\u3059\u3002\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001<a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/indexes\/index-replication.html\">Couchbase \u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092<\/a>\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li><li>useCollections &#8211;  (\u30aa\u30d7\u30b7\u30e7\u30f3) \u30c7\u30d5\u30a9\u30eb\u30c8\u306f \u3067<code>false<\/code>\u3067\u3059\u3002<br><code>true<\/code>\u306e\u5834\u5408\u3001\u6307\u5b9a\u3055\u308c\u305f\u30b9\u30b3\u30fc\u30d7\u3001\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u5bfe\u3057\u3066\u540c\u671f\u3055\u308c\u307e\u3059\u3002<br><code>false<\/code>\u306e\u5834\u5408\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30b9\u30b3\u30fc\u30d7\u3001\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\uff08<code>\u30d0\u30b1\u30c3\u30c8\u540d._default._default<\/code>\uff09\u306b\u5bfe\u3057\u3066\u540c\u671f\u3055\u308c\u307e\u3059\u3002\u3053\u308c\u306f\u3001Couchbase \u30d0\u30fc\u30b8\u30e7\u30f3 7.0 \u4ee5\u964d\u306b\u306e\u307f\u9069\u7528\u3055\u308c\u307e\u3059\u3002<\/li><\/ul><\/li><\/ul>\n\n\n\n<p>\u30ec\u30d7\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>sourceEntities &#8211; \u3069\u306e\u3088\u3046\u306b\u540c\u671f\u3059\u308b\u304b\u3068\u3044\u3063\u305f\u5bfe\u5fdc\u4ed8\u3051\u3084\u8a2d\u5b9a\u3092\u8a18\u8f09<\/li><\/ul>\n\n\n\n<p>\u305d\u306e\u4ed6\u306e\u69cb\u6210\u30d1\u30e9\u30e1\u30fc\u30bf<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>sourceChangeRetention &#8211; (\u30aa\u30d7\u30b7\u30e7\u30f3) \u30c7\u30d5\u30a9\u30eb\u30c8\u306f 5\u65e5\u3067\u3059\u3002\u5909\u66f4\u8ffd\u8de1\u306e\u305f\u3081\u306b\u30bd\u30fc\u30b9DB\u4e0a\u3067\u4fdd\u6301\u3055\u308c\u308b\u30c7\u30fc\u30bf\u306e\u4fdd\u6301\u65e5\u6570\u3092\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<br>SQL Server\u306e\u5834\u5408\u306f\u5909\u66f4\u3092\u8ffd\u8de1\u3059\u308b\u305f\u3081\u306e\u65b9\u6cd5\u3068\u3057\u3066\u3001<a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/ja-jp\/sql\/relational-databases\/track-changes\/about-change-tracking-sql-server?view=sql-server-ver16\" data-type=\"URL\" data-id=\"https:\/\/learn.microsoft.com\/ja-jp\/sql\/relational-databases\/track-changes\/about-change-tracking-sql-server?view=sql-server-ver16\" target=\"_blank\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30ed\u30b0\u3092\u4f7f\u7528\u3057\u305f\u5909\u66f4\u8ffd\u8de1<\/a>\u3068<a rel=\"noreferrer noopener\" href=\"https:\/\/learn.microsoft.com\/ja-jp\/sql\/relational-databases\/track-changes\/about-change-data-capture-sql-server?view=sql-server-ver16\" target=\"_blank\">CDC\u6a5f\u80fd\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5<\/a>\u306e2\u7a2e\u985e\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002<\/li><li>copySourceEntitiesAtStartup &#8211; \u521d\u56de\u8d77\u52d5\u6642\u306b Gluesync \u304c\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u3092\u30b3\u30d4\u30fc\u3059\u308b\u304b\u3069\u3046\u304b\u3092\u793a\u3059\u30d6\u30fc\u30eb\u5024\u3067\u3059\u3002<\/li><li>maxTransactionCountPerIteration &#8211; \u540c\u6642\u306b\u51e6\u7406\u3055\u308c\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u6700\u5927\u6570\u3092\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/li><li>maxItemsCountPerTransaction &#8211; 1 \u3064\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5185\u3067\u51e6\u7406\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u884c\u306e\u6700\u5927\u6570\u3092\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u5f71\u97ff\u3092\u53d7\u3051\u308b\u884c\u306e\u30da\u30fc\u30b8\u30c9\u30fb\u30ea\u30fc\u30c9\u3092\u4f34\u3044\u307e\u3059\u3002<\/li><li>maxMigrationItemsCountPerIteration &#8211; \u30c7\u30d5\u30a9\u30eb\u30c8\u306f 1000 \u3067\u3059\u3002\u3053\u308c\u306f\u3001\u521d\u671f\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u30d7\u30ed\u30bb\u30b9\u306b\u3088\u3063\u3066\u30b9\u30ec\u30c3\u30c9\u3054\u3068\u306b\u30ed\u30fc\u30c9\u3055\u308c\u308b\u30c7\u30fc\u30bf\u306e\u5404\u30c1\u30e3\u30f3\u30af\u306e\u30b5\u30a4\u30ba\u3067\u3059\u3002\u7279\u5b9a\u306e\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u306e\u30cb\u30fc\u30ba\u306b\u5fdc\u3058\u3066\u305d\u306e\u5024\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/li><\/ul>\n\n\n\n<p>\u4eca\u56de\u306f\u30c6\u30b9\u30c8\u7528\u306e\u74b0\u5883\u3067\u3042\u308b\u305f\u3081\u3001\u540c\u30b5\u30fc\u30d0(192.168.33.15)\u4e0a\u3067\u30b3\u30f3\u30c6\u30ca\u3068\u3057\u3066SQL Server\u3068CouchBase\u304c\u5b9f\u884c\u3055\u308c\u3066\u304a\u308a\u3001SQL Server\u3092\u30bd\u30fc\u30b9\u3068\u3057\u3066\u8a2d\u5b9a\u3001CouchBase\u3092\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u3057\u3066\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30bd\u30fc\u30b9\u3068\u306a\u308bSQL Server\u4e0a\u306eDRIVERS\u30c6\u30fc\u30d6\u30eb<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"792\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-1024x792.png\" alt=\"\" class=\"wp-image-7141\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-1024x792.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-300x232.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-768x594.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image.png 1345w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308bCouchBase\u4e0a\u306e\u7a7a\u306edemo\u30d0\u30b1\u30c3\u30c8<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-2-1024x510.png\" alt=\"\" class=\"wp-image-7143\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-2-1024x510.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-2-300x149.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-2-768x383.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-2.png 1194w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30ec\u30d7\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a\u3068\u3057\u3066\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u3001\u30bd\u30fc\u30b9\u3068\u306a\u308bSQL Server\u4e0a\u306eDRIVERS\u30c6\u30fc\u30d6\u30eb\u306e\u5404\u30ec\u30b3\u30fc\u30c9\u3092\u3001CouchBase\u4e0a\u306edata\u30b9\u30b3\u30fc\u30d7\u306b\u5404\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u3057\u3066\u914d\u7f6e\u3059\u308b\u5358\u7d14\u306a\u8a2d\u5b9a\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    \"sourceEntities\": {\n      \"tableSync\": {\n        \"schema\": \"dbo\",\n        \"table\": \"DRIVERS\",\n        \"type\": \"drivers\",\n        \"scope\": \"data\"\n      }\n    }<\/code><\/pre>\n\n\n\n<p>\u3088\u308a\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3082\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u305d\u308c\u306f\u6b21\u56de\u4ee5\u964d\u306b\u3054\u7d39\u4ecb\u4e88\u5b9a\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u69cb\u6210\u306f\u3053\u308c\u3067\u5b8c\u4e86\u3067\u3059\u306e\u3067\u3001\u5b9f\u969b\u306bGlueSync\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>climb@gs-forblog:~$ docker compose start\n&#91;+] Running 1\/1\n &#x2714; Container climb-gluesync-s2n-1  Started      0.3s \nclimb@gs-forblog:~$ \n<\/code><\/pre>\n\n\n\n<p>\u5404\u30ec\u30b3\u30fc\u30c9\u304c\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u3057\u3066\u540c\u671f\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-6-1024x546.png\" alt=\"\" class=\"wp-image-7147\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-6-1024x546.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-6-300x160.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-6-768x409.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-6.png 1439w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-4-1024x546.png\" alt=\"\" class=\"wp-image-7145\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-4-1024x546.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-4-300x160.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-4-768x409.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-4.png 1439w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u521d\u671f\u540c\u671f\u5f8c\u306f\u5909\u66f4\u3055\u308c\u305f\u30ec\u30b3\u30fc\u30c9\u306e\u307f\u3092\u30ec\u30d7\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3057\u307e\u3059\u306e\u3067\u3001\u4e00\u3064\u306e\u30ec\u30b3\u30fc\u30c9\u306e\u307f\u3092\u66f4\u65b0\u3057\u3066\u307f\u308b\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u306b\u3082\u305d\u308c\u304c\u540c\u671f\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-7.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-7-1024x525.png\" alt=\"\" class=\"wp-image-7148\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-7-1024x525.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-7-300x154.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-7-768x393.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-7.png 1345w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-8-1024x546.png\" alt=\"\" class=\"wp-image-7149\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-8-1024x546.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-8-300x160.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-8-768x409.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-8.png 1439w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u7c21\u5358\u306b\u30ec\u30d7\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3067\u304d\u308bGlueSync\u3067\u3059\u304c\u3001\u305d\u306e\u30b3\u30f3\u30c6\u30ca\u81ea\u4f53\u306f\u30b9\u30c6\u30fc\u30c8\u30ec\u30b9\u3067\u3042\u308a\u3001\u5fc5\u8981\u306a\u7ba1\u7406\u60c5\u5831\uff08\u3069\u3053\u307e\u3067\u30ec\u30d7\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3057\u305f\u304b\u306a\u3069\uff09\u306f\u30bd\u30fc\u30b9\u3084\u30bf\u30fc\u30b2\u30c3\u30c8\u306b\u8a18\u9332\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30bd\u30fc\u30b9\u3067\u7ba1\u7406\u60c5\u5831\u3092\u4fdd\u6301\u3059\u308b\u30c6\u30fc\u30d6\u30eb<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-5-1024x525.png\" alt=\"\" class=\"wp-image-7146\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-5-1024x525.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-5-300x154.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-5-768x393.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-5.png 1345w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u30bf\u30fc\u30b2\u30c3\u30c8\u3067\u7ba1\u7406\u60c5\u5831\u3092\u4fdd\u6301\u3059\u308b\u30b9\u30b3\u30fc\u30d7<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-9-1024x546.png\" alt=\"\" class=\"wp-image-7150\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-9-1024x546.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-9-300x160.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-9-768x409.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-9.png 1439w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-10.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"546\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-10-1024x546.png\" alt=\"\" class=\"wp-image-7151\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-10-1024x546.png 1024w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-10-300x160.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-10-768x409.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2024\/01\/image-10.png 1439w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>\u3053\u306e\u305f\u3081\u3001GlueSync\u304c\u518d\u8d77\u52d5\u3057\u305f\u969b\u306b\u306f\u3053\u308c\u3089\u306e\u7ba1\u7406\u60c5\u5831\u3092\u8aad\u307f\u53d6\u3063\u3066\u518d\u958b\u3057\u307e\u3059\u306e\u3067\u3001\u521d\u671f\u540c\u671f\u304b\u3089\u3084\u308a\u76f4\u3059\u5fc5\u8981\u3082\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001\u4eca\u56de\u306fMicrosoft SQL Server\u304b\u3089CouchBase\u3078\u306e\u30ec\u30d7\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4ed6\u306b\u3082\u3001\u30bd\u30fc\u30b9\u3068\u3057\u3066IBM Db2\u3001IBM i (AS\/400)\u3001Microsoft SQL Server\u3001 Oracle Database\u3001 MariaDB\u3001 MySQL\u3001PostgreSQL\u3001 Sybase ASE \/ SAP SQL Anywhere\u3001Couchbase\u3001 Amazon DynamoDB\u3001Apache HBase\u3001MongoDB\u3001\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u3057\u3066Aerospike\u3001Apache Kafka\u3001 Amazon S3 \u3001 Google Cloud Storage\u3001RavenDB\u3001 Solace PubSub+\u306a\u3069\u3082\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684\u306a\u30b5\u30dd\u30fc\u30c8\u69cb\u6210\u306b\u95a2\u3057\u3066\u306f\u4e0b\u8a18\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<br><a href=\"https:\/\/www.climb.co.jp\/soft\/gluesync\/#system\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.climb.co.jp\/soft\/gluesync\/#system<\/a><\/p>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u7c21\u5358\u306b\u69cb\u6210\u3057\u3066NoSQL\u306b\u540c\u671f\u3067\u304d\u308bGlueSync\u3001\u3054\u8208\u5473\u3042\u308a\u307e\u3057\u305f\u3089\u662f\u975e\u5f0a\u793e\u307e\u3067\u304a\u554f\u3044\u5408\u308f\u305b\u304f\u3060\u3055\u3044\u3002<br><a rel=\"noreferrer noopener\" href=\"https:\/\/www.climb.co.jp\/soft\/contact\/contact.php\" target=\"_blank\">https:\/\/www.climb.co.jp\/soft\/contact\/contact.php<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>GlueSync\u306f\u30c7\u30fc\u30bf\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001\u65e2\u5b58\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3068\u5927\u304d\u304f\u7570\u306a\u308a\u3001\u4ee5\u4e0b\u306e\u70b9\u306b\u7279\u5316\u3057\u3066\u3044\u307e\u3059\u3002 \u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3067\u30b9\u30c6\u30fc\u30c8\u30ec\u30b9\u306a\u30b3\u30f3\u30c6\u30ca\u3068\u3057\u3066\u52d5\u4f5c NoSQL\u3084\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u3078\u306e\u30c7\u30fc\u30bf\u9023\u643a \u30b3\u30f3\u30c6\u30ca\u3067 &hellip; <a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/7135\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[456,465],"tags":[467,468,469,470,16,457,466],"class_list":["post-7135","post","type-post","status-publish","format-standard","hentry","category-molo17","category-gluesync","tag-467","tag-468","tag-469","tag-470","tag-sql-server","tag-nosql","tag-couchbase"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/7135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=7135"}],"version-history":[{"count":6,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/7135\/revisions"}],"predecessor-version":[{"id":7170,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/7135\/revisions\/7170"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=7135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=7135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=7135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}