\ube48\ubc88\ud558\uc9c0 \uc54a\uc740 mssql -> mysql \ub85c\uc758 DB porting \ubb38\uc81c\uc5d0 \uace8\uba38\ub9ac\ub97c \uc553\ub2e4\uac00 \uc801\ud569\ud55c \ubc29\ubc95\uc744 \ucc3e\uc544\ub0b4\uc11c \uadf8 \ubc29\ubc95\uc744 \uc81c\uc2dc\ud574\ubcf8\ub2e4.<\/p>\n
mssql 2000 \uc5d0 \ud55c\uae00\uc744 \ud3ec\ud568\ud558\ub294 DB\ub97c \uac00\uc9c4 \uc720\uc800\uac00 mysql\ub85c \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\ub294\ub370 \uc788\uc5b4\uc11c<\/p>\n
\ubbfc\uac10\ud55c \ubd80\ubd84\uae4c\uc9c0 \ub2e4 \uc804\ub2ec\ub418\uc9c4 \uc54a\uc9c0\ub9cc \ub370\uc774\ud130\ub97c \uc720\uc2e4\ub2f9\ud558\uc9c0 \uc54a\uace0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc801\ud569\ud55c \ud234\uc774 \uc788\ub2e4.<\/p>\n
Google \uc5d0\uc11c mssql to mysql \ub85c \uac80\uc0c9\uc744 \ud574\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ud398\uc774\uc9c0\ub97c \ub9cc\ub0a0 \uc218 \uc788\ub2e4.<\/p>\n
http:\/\/www.kofler.cc\/mysql\/mssql2mysql.html<\/p>\n
\uce5c\uc808\ud558\uac8c\ub3c4 \ubb34\ub8cc\ub85c \ubc30\ud3ec\ud558\uace0 \uc788\ub294\ub370… \uc798 \uc77d\uc5b4\ubcf4\uba74 \ub2f5\uc774 \uc788\uc744 \uac83\uc774\ub2e4.<\/p>\n
mssql2mysql-gui2.zip \ud30c\uc77c (\ucca8\ubd80\ud30c\uc77c) \uc744 \ub2e4\uc6b4\ubc1b\uc544\uc11c \uc0ac\uc6a9\ud574\ubcf4\uba74 \uc801\uc808\ud55c interface\ub85c \uad6c\uc131\ub41c\uac78 \ubcfc \uc218 \uc788\ub2e4. <\/p>\n
\uc798\uc368\ubcf4\uc790… \ud558\uc9c0\ub9cc \uc2dc\ud589\ucc29\uc624\ub97c \uc880 \uc904\uc774\uace0\uc790 \ud558\uba74 \ub2e4\uc74c\uc744 \uc77d\uc5b4\ubcf4\uba74 \ub3c4\uc6c0\uc774 \ub420 \uac83 \uac19\ub2e4.<\/p>\n
\ub0b4\uac00 \uc791\uc5c5\ud558\ub824\ub294 PC\uc5d0 mysql\uc744 \uc124\uce58\ud574\uc11c \uadf8 \uacf3\uc73c\ub85c \ub370\uc774\ud130\ub97c \ube7c\ub0bc\uc9c0 \ub3d9\uc791\uc911\uc778 \uc6d0\uaca9 \uc11c\ubc84\ub85c \ubc14\ub85c \ub370\uc774\ud130\ub97c \ubcf4\ub0bc\uc9c0 \uacb0\uc815\ud55c\ub2e4.<\/p>\n
\uc804\uc790\ub97c \uc120\ud0dd\ud588\uc744 \uacbd\uc6b0 dump \ud615\uc2dd\uc73c\ub85c \ud30c\uc77c\uc744 \ubcf5\uc6d0\ud574\uc918\uc57c \ud558\ub294 \ubc88\uac70\ub85c\uc6c0\uc774 \uc788\uc9c0\ub9cc \uc6d0\uaca9 \uc811\uc18d\uc5d0 \ub300\ud55c \ubb38\uc81c\uc810\uc5d0\uc11c \uc548\uc804\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\ud6c4\uc790\ub97c \uc120\ud0dd\ud574\uc11c \uc6d0\uaca9\uc73c\ub85c \ubc14\ub85c \ubcf4\ub0b4\uace0\uc790 \ud560 \uacbd\uc6b0 \/etc\/my.cnf \ud30c\uc77c\uc5d0\uc11c\uc758 \ub124\ud2b8\uc6cd \uc124\uc815\uc774 \uc6d0\uaca9\uc9c0\uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub294\uc9c0 \uadf8\ub9ac\uace0, mysql \uc758 user \ud14c\uc774\ube14\uc5d0 host \uac12\uc774 % \ub85c \uc124\uc815 \ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud574 \ubcf4\uc790. \uc774\uc5d0 \ub300\ud55c \ubb38\uc11c\ub294 \uac80\uc0c9\uc744 \ud1b5\ud558\uba74 \uc5bc\ub9c8\ub4e0\uc9c0 \uad6c\ud560 \uc218 \uc788\uc73c\ub2c8 \uc2a4\uc2a4\ub85c \ud574\ubcf4\uc2dc\uae38…<\/p>\n
\uc774\uc815\ub3c4\uac00 \uc900\ube44\ub418\uc5c8\ub2e4\uba74 \ub124\ud2b8\uc6cd\uc124\uc815\uc774 \uc798 \ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4. <\/p>\n
\uc774 \ud504\ub85c\uadf8\ub7a8\uc758 \ud2b9\uc131\uc0c1 mysql\uc758 default port \uac12\uc744 \ubcc0\ub3d9 \ud560 \uc218 \uc5c6\uc74c\uc73c\ub85c \ubc18\ub4dc\uc2dc 3306 \uc774 TCP\ub85c LISTEN \uc774 \ub418\uc5b4 \uc788\uc5b4\uc57c\ub9cc \ud55c\ub2e4.<\/p>\n
\ub2e4\uc74c\uacfc \uac19\uc740 \uba85\ub839\uc5b4\ub85c \uc6d0\uaca9\uc9c0 \uc11c\ubc84\uac00 \ubc29\ud654\ubcbd\uc5d0 \uac78\ub824\uc788\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<\/p>\n
$ telnet 123.xxx.xxx.xxx 3306<\/p>\n
\uc6d0\uaca9\uc9c0\uc5d0 \ub300\ud55c \uc811\uadfc\ud5c8\uc6a9\uc744 \uac70\ubd80\ud55c\ub2e4\ub294 \uba85\ub839\uc5b4\uac00 \ub098\uc624\uc9c0 \uc54a\uace0 \ud504\ub86c\ud504\ud2b8\uac00 \uc5f4\ub9b0\ub2e4\uba74 \uc811\uadfc\uc774 \ud5c8\uc6a9\ub41c\uac83\uc774\ub2e4. (\uc5f4\ub838\uc74c\uc5d0\ub3c4 \uc811\uadfc\uc774 \uc548\ub41c\ub2e4\uba74 DB\uc758 \uc0ac\uc6a9\uc790 \uc124\uc815\uc744 \ub2e4\uc2dc \ud655\uc778\ud574\ubcf4\uc790.. mysql \ub370\ubaac\uc744 \uc7ac\uc2dc\uc791\ud574\uc8fc\ub294 \uac83\ub3c4 \uc788\uc9c0\ub9d0\uc790)<\/p>\n
\uc708\ub3c4\uc6b0\uc5d0 mysql ODBC\ub97c \uc124\uce58\ud558\uace0 \uc5f0\uacb0\uc744 \ud574\uc918\uc57c\ub9cc \uc774 \ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\ub9cc\uc57d ODBC\uac00 \uc5c6\ub2e4\uba74 mssql \uc744 mysqldump \ud0c0\uc785\uc73c\ub85c \ud30c\uc77c\ub85c \ub9cc\ub4e4\uc5b4 \ub0bc \uc218 \uc788\ub294 \uae30\ub2a5\uc774 \uc788\ub2e4.<\/p>\n
\ubb3c\ub860 \ubcf5\uc6d0\uc2dc\ucf1c\uc8fc\ub294 \ubc88\uac70\ub85c\uc6c0\uc774 \uc788\uaca0\uc9c0\ub9cc \uae09\ud55c\ub370\ub85c \uc4f0\uae30 \uc27d\ub2e4.<\/p>\n
index \uac12\uc774\ub098 primary key\uac12 date type \uc744 \uc798 \ubcc0\ud658 \uc2dc\ucf1c\uc900\ub2e4.<\/p>\n
\uac04\ud639 \uc708\ub3c4\uc6b0\uc6a9 mysql \uc11c\ubc84\ub85c \uc804\ub2ec\ub41c \ud30c\uc77c\uc744 dump \ud560\ub54c \ud55c\uae00\uc774 \uae68\uc9c0\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370 \uc774\ub7f4\uacbd\uc6b0 \uc9c1\uc811 client pc\uc5d0 DB\ub97c \ud30c\uc77c\ub85c \ub9cc\ub4e4\uc5b4\ub0b4\uc11c \ub2e4\uc2dc \uc11c\ube44\uc2a4 \ud574\uc8fc\uace0\uc790 \ud558\ub294 \uc11c\ubc84\uc5d0 dump \uc2dc\ucf1c\uc8fc\uba74 \ub370\uc774\ud130\ub97c \uc644\uc804\ud788 \uc7ac\uc0ac\uc6a9 \ud560 \uc218 \uc788\ub2e4.
\n1221123276.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\ube48\ubc88\ud558\uc9c0 \uc54a\uc740 mssql -> mysql \ub85c\uc758 DB porting \ubb38\uc81c\uc5d0 \uace8\uba38\ub9ac\ub97c \uc553\ub2e4\uac00 \uc801\ud569\ud55c \ubc29\ubc95\uc744 \ucc3e\uc544\ub0b4\uc11c \uadf8 \ubc29\ubc95\uc744 \uc81c\uc2dc\ud574\ubcf8\ub2e4. mssql 2000 \uc5d0 \ud55c\uae00\uc744 \ud3ec\ud568\ud558\ub294 DB\ub97c \uac00\uc9c4 \uc720\uc800\uac00 mysql\ub85c \ub370\uc774\ud130\ub97c \ubcc0\ud658\ud558\ub294\ub370 \uc788\uc5b4\uc11c \ubbfc\uac10\ud55c \ubd80\ubd84\uae4c\uc9c0 \ub2e4 \uc804\ub2ec\ub418\uc9c4 \uc54a\uc9c0\ub9cc \ub370\uc774\ud130\ub97c \uc720\uc2e4\ub2f9\ud558\uc9c0 \uc54a\uace0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc801\ud569\ud55c \ud234\uc774 \uc788\ub2e4. Google \uc5d0\uc11c mssql to mysql \ub85c \uac80\uc0c9\uc744 \ud574\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ud398\uc774\uc9c0\ub97c \ub9cc\ub0a0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-1472","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1472"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1472\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}