{"id":4938,"date":"2022-03-08T16:09:12","date_gmt":"2022-03-08T07:09:12","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=4938"},"modified":"2022-03-08T18:03:38","modified_gmt":"2022-03-08T09:03:38","slug":"sql-server-to-mariadb-%eb%8d%b0%ec%9d%b4%ed%83%80-%ec%a0%84%ec%86%a1%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=4938","title":{"rendered":"SQL Server to MariaDB \ub370\uc774\ud0c0 \uc804\uc1a1\ud558\uae30"},"content":{"rendered":"

SQL Server to MariaDB \ub370\uc774\ud0c0 \uc804\uc1a1\ud558\uae30<\/h1>\n

SQL Server \uc5d0 MariaDB ODBC \uc124\uc815\ud558\uae30<\/h2>\n

\ucc38\uc870\uc0ac\uc774\ud2b8<\/a><\/p>\n

ODBC \ub4dc\ub77c\uc774\ubc84 \ub2e4\uc6b4\ub85c\ub4dc<\/h3>\n

\uc5ec\uae30<\/a> \uc5d0\uc11c ODBC \ub4dc\ub77c\uc774\ubc84\ub97c \ub2e4\uc6b4\ub85c\ub4dc \ud569\ub2c8\ub2e4.<\/p>\n

\"\"<\/p>\n

\ub2e4\uc6b4\ubc1b\uc740 \ud30c\uc77c\uc744 SQL Server \uac00 \uc124\uce58\ub41c \uc11c\ubc84\uc5d0 \uc124\uce58\ud569\ub2c8\ub2e4.<\/p>\n

\uc6d0\ubcf8 \uad00\ub9ac\uc790 \uc124\uc815<\/h3>\n

Windows \uad00\ub9ac\ub3c4\uad6c > ODBC \ub370\uc774\ud130 \uc6d0\ubcf8 \uad00\ub9ac\uc790(64\ube44\ud2b8)<\/code> \ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n

\uc2dc\uc2a4\ud15c DSN \uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.
\n(\uc0ac\uc6a9\uc790 DSN \uc73c\ub85c \ucd94\uac00\ud558\ub294 \uacbd\uc6b0, \ub85c\uadf8\uc778 \uacc4\uc815\uacfc DB \uc2e4\ud589 \uacc4\uc815\uc774 \ub2e4\ub974\uba74 \uc778\uc2dd\uc744 \ubabb\ud569\ub2c8\ub2e4.)<\/p>\n

\ucd94\uac00\ub97c \ub204\ub974\uace0, MariaDB ODBC Driver \ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/p>\n

\uc811\uc18d\uc815\ubcf4\ub97c \uc785\ub825\ud574 \uc90d\ub2c8\ub2e4.<\/p>\n

Character Set\uc740 utf8 \ub85c \ud569\ub2c8\ub2e4.<\/p>\n

\uc5f0\uacb0\ub41c \uc11c\ubc84 \uc124\uc815<\/h2>\n

\uc5f0\uacb0\ub41c \uc11c\ubc84\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n

\uacf5\uae09\uc790\uc5d0\ub294 OLE DB Provider for ODBC Drivers \ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.
\n\uc81c\ud488\uc774\ub984\/\ub370\uc774\ud0c0\uc6d0\ubcf8\/\uacf5\uae09\uc790\ubb38\uc790\uc5f4 \uc5d0 \uc704\uc5d0\uc11c \uc0dd\uc131\ud55c \uacf5\uae09\uc790 \uc774\ub984\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.
\n\uce74\ub2ec\ub85c\uadf8\uc5d0\ub294 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uba85\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n

\ubcf4\uc548\ud0ed\uc5d0\uc11c \uc811\uc18d\ud560 \uc544\uc774\ub514\/\ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud574 \uc90d\ub2c8\ub2e4.<\/p>\n

\uc544\ub798 \uba85\ub839\uc73c\ub85c \uc815\uc0c1\uc801\uc73c\ub85c \uc811\uc18d \uac00\ub2a5\ud55c\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n

select top 100 *\nfrom openquery(\uacf5\uae09\uc790\uc774\ub984, 'select * from \ud14c\uc774\ube14\uba85')<\/code><\/pre>\n
\uc544\ub798 \uba85\ub839\uc73c\ub85c \uc5f0\uacb0\ub41c \uc11c\ubc84\ub85c \ub370\uc774\ud0c0\ub97c \uc804\uc1a1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
INSERT INTO OPENQUERY ([\uc5f0\uacb0\ub41c \uc11c\ubc84\ubcc4\uce6d], 'SELECT [\uceec\ub7fc\uba85] FROM [\ud14c\uc774\ube14\uba85]')\nSELECT [\uceec\ub7fc\uba85] FROM [\uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14\uba85];<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
SQL Server to MariaDB \ub370\uc774\ud0c0 \uc804\uc1a1\ud558\uae30 SQL Server \uc5d0 MariaDB ODBC \uc124\uc815\ud558\uae30 \ucc38\uc870\uc0ac\uc774\ud2b8 ODBC \ub4dc\ub77c\uc774\ubc84 \ub2e4\uc6b4\ub85c\ub4dc \uc5ec\uae30 \uc5d0\uc11c ODBC \ub4dc\ub77c\uc774\ubc84\ub97c \ub2e4\uc6b4\ub85c\ub4dc \ud569\ub2c8\ub2e4. \ub2e4\uc6b4\ubc1b\uc740 \ud30c\uc77c\uc744 SQL Server \uac00 \uc124\uce58\ub41c \uc11c\ubc84\uc5d0 \uc124\uce58\ud569\ub2c8\ub2e4. \uc6d0\ubcf8 \uad00\ub9ac\uc790 \uc124\uc815 Windows \uad00\ub9ac\ub3c4\uad6c > ODBC \ub370\uc774\ud130 \uc6d0\ubcf8 \uad00\ub9ac\uc790(64\ube44\ud2b8) \ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4. \uc2dc\uc2a4\ud15c DSN \uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. (\uc0ac\uc6a9\uc790 DSN \uc73c\ub85c \ucd94\uac00\ud558\ub294 \uacbd\uc6b0, \ub85c\uadf8\uc778 \uacc4\uc815\uacfc DB \uc2e4\ud589\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-4938","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4938","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4938"}],"version-history":[{"count":9,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4938\/revisions"}],"predecessor-version":[{"id":4949,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4938\/revisions\/4949"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}