{"id":4517,"date":"2021-11-03T21:11:07","date_gmt":"2021-11-03T12:11:07","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4517"},"modified":"2021-11-03T21:11:08","modified_gmt":"2021-11-03T12:11:08","slug":"%ec%9d%b4%ea%b8%b0%ec%a2%85-%eb%a7%88%ec%9d%b4%ea%b7%b8%eb%a0%88%ec%9d%b4%ec%85%98-tool-2","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4517","title":{"rendered":"\uc774\uae30\uc885 \ub9c8\uc774\uadf8\ub808\uc774\uc158 TOOL"},"content":{"rendered":"<p><strong>ISPIRER <\/strong>\uc740 \uc218\ub3d9\uc73c\ub85c \ud558\ub294 SCRIPT \uc791\uc5c5\uc744 \ud1b5\ud55c \uc774\uad00\uacfc \uc2dc\uac04\ucc28\uc774\uac00 \uac70\uc758 \ub098\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. (1\ub2ec \ub370\ubaa8 \uc0ac\uc6a9)<\/p>\n<p>\ub610\ud55c \ucee8\ubc84\ud2b8 \uc2a4\ud06c\ub9bd\ud2b8 \ub610\ud55c \uc815\ud655\ud558\uac8c \ubcc0\ud658\uc774 \ub418\uc5b4 \uc791\uc5c5\uc790\uc758 \uc791\uc5c5 \ub2a5\ub960 \ubc0f \ud3b8\uc758\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc \uac00\uaca9 \ub2e8\uac00\ub294 \uc5c5\uccb4\uc640 \ud611\uc758\ub97c \ud558\uc5ec\uc57c \ub418\ub294 \uac78\ub85c \uc54c\uace0 \uc788\uc73c\uba70, 1\ubc88 \uad6c\uc785\ud558\uba74 \ud3c9\uc0dd \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc544\ub2cc \uae30\uac04 \ub2e8\uc704\ub85c \uacc4\uc57d\uc744 \ud558\uc5ec\uc57c \ub418\ub294 \uac83\uc73c\ub85c \ucd94\uc815 \ub429\ub2c8\ub2e4.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>ESF <\/strong>\uc740 \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud3b8\uc758\uc131\uc740 ISPIRER \ubcf4\ub2e4 \uc6b0\uc218\ud558\uc9c0\ub9cc, \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ub418\ub294 \uc791\uc5c5 \uc2dc\uac04\uc774 \ub108\ubb34 \uc624\ub798 \uac78\ub824\uc11c \uc0ac\uc6a9\ud558\uae30\uc5d0\ub294 \ubb34\ub9ac\uac00 \uc788\uc2b5\ub2c8\ub2e4. (\uc815\uc2dd\ubc84\uc804\uc73c\ub85c \uc0ac\uc6a9\ud568)<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>\uc218\ub3d9(SCRIPT)<\/strong>\ub85c \uc9c4\ud589\ud55c \uc774\uae30\uc885 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc740 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\ub3d9\uc73c\ub85c \uc791\uc131 \ud6c4 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \ud558\uc5ec\uc57c \ud558\uc9c0\ub9cc \uc548\uc815\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc \ubaa8\ub4e0 \uc791\uc5c5 (\ub9c8\uc774\uadf8\ub808\uc774\uc158, \ud568\uc218, \ud2b8\ub9ac\uac70)\uc744 \uc218\ub3d9\uc73c\ub85c \uc791\uc5c5\ud574\uc57c \ud558\ub294 \ub2e8\uc810\uc774 \uc788\uc5b4 \ud3b8\uc758\uc131 \uba74\uc5d0\uc11c\ub294 \uc88b\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>\uc774\uae30\uc885 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\uad00 <\/strong><strong>(ORACLE TO MY SQL)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>\uc11c\ub860 :<\/strong> Oracle\uc5d0\uc11c MySQL\uacfc \uac19\uc740 \uc774\uae30\uc885 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc704\ud55c \uc720\ub8cc \ud234\uacfc \uc218\ub3d9 \uc774\uad00 \ubc29\ubc95\uc5d0 \ub300\ud55c \ube44\uad50<\/p>\n<p>ISPIRER , ESF, SCRIPT \uc774\uad00 \ud14c\uc2a4\ud2b8 \uc9c4\ud589<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\ud14c\uc2a4\ud2b8 :<\/strong> 1. ORACLE 1.8G (SHPP_CUST) \uc758 \ub370\uc774\ud130\ub97c MYSQL\ub85c \uc774\uad00 (\uc778\ub371\uc2a4, \ud568\uc218 ,\ud391\uc158) \uc18d\ub3c4 \ube44\uad50<\/p>\n<ol start=\"2\">\n<li>\uc774\uad00 \uc2dc \uc18d\ub3c4 \ube44\uad50<\/li>\n<li>LOB \ub370\uc774\ud130 \uc774\uad00 \uc18d\ub3c4 \ube44\uad50 (LOB_TAB)<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>\uacb0\ub860 :<\/strong> ISPIRER\uc774 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\ub294 SCRIPT \ubc29\uc2dd\uacfc \uc18d\ub3c4\uba74\uc5d0\uc11c \ucc28\uc774\uac00 \uc5c6\uc73c\uba70, \uc9c1\uad00\uc801\uc778 UI\ub85c \uc0ac\uc6a9\uc790 \ud3b8\uc758\uc131\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e8\uac00\ub9cc \uad1c\ucc2e\ub2e4\uba74 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \uc0ac\uc6a9\ud558\uc5ec\ub3c4 \uc88b\uc740 \uc194\ub8e8\uc158 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p>SCRIPT \uc774\uad00\uc740 \uc0ac\uc6a9\uc790\uc758 SCRIPT \uc791\uc131\uc774 \ubd88\ud3b8\ud558\uc9c0\ub9cc, \uc18d\ub3c4\uba74\uc5d0\uc11c\ub294 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ucd94\uac00\uc801\uc778 \ub2e8\uc810\uc740 LOB \ub370\uc774\ud130 \uad00\ub828 \uc5d0\ub7ec\uac00 \ub098\uba74 \uc81c\uc870\uc0ac\uc5d0 \uc694\uccad\ud574\uc11c \ud574\uacb0\ub41c \uc124\uce58\ud30c\uc77c\uc744 \ub2e4\uc2dc \uc124\uce58 \ud574\uc11c \uc9c4\ud589\uc744 \ud558\uc5ec\uc57c \ud568<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\ud14c\uc2a4\ud2b8 \ube44\uad50 \uc790\ub8cc<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"236\">\uc81c\ud488 \/ \ub0b4\uc5ed<\/td>\n<td width=\"151\">\uc774\uad00<\/td>\n<td width=\"113\">ISPIRER<\/td>\n<td width=\"104\">ESF<\/td>\n<td width=\"93\">SCRIPT<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"236\">\ub370\uc774\ud130 \uc774\uad00\ubc29\uc2dd<\/td>\n<td width=\"151\">\ub370\uc774\ud130 \ub2e4\uc6b4\ub85c\ub4dc<\/td>\n<td width=\"113\">EXPORT<\/td>\n<td width=\"104\">EXPORT<\/td>\n<td width=\"93\">LODER<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">\ub370\uc774\ud130 \uc5c5\ub85c\ub4dc<\/td>\n<td width=\"113\">LODER<\/td>\n<td width=\"104\">LODER<\/td>\n<td width=\"93\">LODER<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"236\">TABLE 1.8G\uc774\uad00\/LOB \uc18d\ub3c4<\/td>\n<td width=\"151\">\ub370\uc774\ud130 \ub2e4\uc6b4\ub85c\ub4dc<\/td>\n<td width=\"113\">5m<\/td>\n<td width=\"104\">5m<\/td>\n<td width=\"93\">5m<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">\ub370\uc774\ud130 \uc5c5\ub85c\ub4dc<\/td>\n<td width=\"113\">4m 42s<\/td>\n<td width=\"104\">2hr 33m<\/td>\n<td width=\"93\">4m 18s<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\uc5b8\uc5b4\uc774\uad00 (\ud55c\uae00 \uc22b\uc790, \uc601\uc5b4 \ub4f1)<\/td>\n<td rowspan=\"5\" width=\"151\">&nbsp;<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">O<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">Function ,trigger,<\/p>\n<p>procedure, view \uc790\ub3d9\uc774\uad00 \uc5ec\ubd80<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">X<\/td>\n<td width=\"93\">X<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\uc774\uad00 \uc5d0\ub7ec \uc2dc \ud655\uc778 \uc5ec\ubd80<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">O<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\ucee4\uc2a4\ud140 \uc5ec\ubd80 (UI, SCRIPT\uc218\uc815)<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">X<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\ud0c0 \uc774\uae30\uc885 \uc9c0\uc6d0 \uc5ec\ubd80<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">O<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>\ucc38\uc870 \uc0ac\uc774\ud2b8 : <\/strong><\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.sqlines.com\/oracle-to-mysql\">http:\/\/www.SQLines.com\/oracle-to-mySQL<\/a> (\ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \uc774\uc288, \ub808\ud37c\ub7f0\uc2a4 \ub4f1 \ube44\uad50)<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"2\">\n<li><strong>\ud55c\uad6d \ub0b4 \uad50\uc721\ud574\uc8fc\ub294 \uc5c5\uccb4<\/strong> :<\/li>\n<\/ol>\n<p><a href=\"https:\/\/estudy.kitri.re.kr\/usrs\/eduRegMgnt\/eduRegInfoDetailForm.do?p_crscd=441&amp;p_crsseq_id=335&amp;p_view_type=&amp;CRSCD=&amp;CRSSEQ_ID=335&amp;p_ctgrycd=3000&amp;p_hmpgcd=32&amp;mkey=47794&amp;p_srch_year=2018\">https:\/\/estudy.kitri.re.kr\/usrs\/eduRegMgnt\/eduRegInfoDetailForm.do?p_crscd=441&amp;p_crsseq_id=335&amp;p_view_type=&amp;CRSCD=&amp;CRSSEQ_ID=335&amp;p_ctgrycd=3000&amp;p_hmpgcd=32&amp;mkey=47794&amp;p_srch_year=2018<\/a><\/p>\n<p>&nbsp;<\/p>\n<ol start=\"3\">\n<li><strong>\ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc0c1\uc6a9TOOL<\/strong><\/li>\n<\/ol>\n<p><strong>Ispirer (SQL WAY)<\/strong> : <a href=\"http:\/\/www.ispirer.com\/products\/oracle-to-mysql-migration\">http:\/\/www.ispirer.com\/products\/oracle-to-mySQL-migration<\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/p>\n<p>2. Source\uc640 Target\uc744 DB\uc5d0 \ub9de\uac8c \uc790\ub3d9\uc73c\ub85c \ud14c\uc774\ube14 \uad6c\uc870 \ubc0f \ud568\uc218, \ud504\ub85c\uc2dc\uc838, \ud2b8\ub9ac\uac70 \ub4f1\uc744 \ubcc0\uacbd\ud574 \uc8fc\uace0<\/p>\n<p>\uc774\uad00\ud574 \uc90c<\/p>\n<p>3. UI\uac00 \uae54\ub054\ud558\uba70, \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \ud56d\ubaa9\ub9cc \uc774\uad00\uc744 \ud560 \uc218 \uc788\uac8c \ub418\uc5b4 \uc788\uc74c<\/p>\n<p>4. \uc18d\ub3c4\uac00 \ube60\ub984<\/p>\n<p>5. \uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">\uac00\uaca9\uc774 \ube44\uc308<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>ESF DMT : <\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/p>\n<p>2. UI\uac00 \uae54\ub054\ud558\uba70, \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \ud56d\ubaa9\ub9cc \uc774\uad00\uc744 \ud560 \uc218 \uc788\uac8c \ub418\uc5b4 \uc788\uc74c<\/p>\n<p>3.\uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/p>\n<p>2. \ub370\uc774\ud130 \ubcc0\ud658\ub9cc \ub428 (\ud504\ub85c\uc2dc\uc838 \ubc0f \ud568\uc218, \ud391\uc158 \ub4f1 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\uc5ec\uc57c \ud568)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>DBLoader : <\/strong><a href=\"http:\/\/www.dbload.com\/\"><strong>http:\/\/www.dbload.com\/<\/strong><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/p>\n<p>2. \ub370\uc774\ud130 \ubcc0\ud658\ub9cc \ub428 (\ud504\ub85c\uc2dc\uc838 \ubc0f \ud568\uc218, \ud391\uc158 \ub4f1 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\uc5ec\uc57c \ud568)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>DBCONVERT : <\/strong><a href=\"http:\/\/dbconvert.com\/convert-oracle-to-mysql-pro.php\"><strong>http:\/\/dbconvert.com\/convert-oracle-to-mySQL-pro.php<\/strong><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">1.\u00a0\u00a0\u00a0\u00a0 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/p>\n<p>2.\u00a0\u00a0\u00a0\u00a0 \uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/p>\n<p>2. \ub370\uc774\ud130 \ubcc0\ud658\ub9cc \ub428 (\ud504\ub85c\uc2dc\uc838 \ubc0f \ud568\uc218, \ud391\uc158 \ub4f1 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\uc5ec\uc57c \ud568)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Spactral Core : <\/strong><a href=\"http:\/\/www.spectralcore.com\/omegasync\/\"><strong>http:\/\/www.spectralcore.com\/omegasync\/<\/strong><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/p>\n<p>2 .\uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/p>\n<p>2. \ub370\uc774\ud130 \ubcc0\ud658\ub9cc \ub428 (\ud504\ub85c\uc2dc\uc838 \ubc0f \ud568\uc218, \ud391\uc158 \ub4f1 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\uc5ec\uc57c \ud568)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>\ub9c8\uc774\uadf8\ub808\uc774\uc158 \ubb34\ub8ccTOOL<\/strong><\/p>\n<p><strong>SQLdeveloper : \uc624\ub77c\ud074 \uc804\uc6a9 \ud234<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">\uc5c6\uc74c<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/p>\n<p>2. \ub370\uc774\ud130 \ubcc0\ud658\ub9cc \ub428 (\ud504\ub85c\uc2dc\uc838 \ubc0f \ud568\uc218, \ud391\uc158\ub4f1 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\uc5ec\uc57c \ud568)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>mySQL workbench : <\/strong><a href=\"https:\/\/dev.mysql.com\/downloads\/workbench\/\"><strong>https:\/\/dev.mySQL.com\/downloads\/workbench\/<\/strong><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">1. MYSQL \uc804\uc6a9 \uc774\uad00 \ud234<\/p>\n<p>2. UI\uac00 \uc9c1\uad00\uc801\uc784<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/p>\n<p>2. \ub370\uc774\ud130 \ubcc0\ud658\ub9cc \ub428 (\ud504\ub85c\uc2dc\uc838 \ubc0f \ud568\uc218, \ud391\uc158\ub4f1 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\uc5ec\uc57c \ud568)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>\uc2a4\ud06c\ub9bd\ud2b8 \uc774\uad00<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"66\">\uc7a5\uc810<\/td>\n<td width=\"631\">1. \ub370\uc774\ud130 \uc774\uad00\uc774 \ube60\ub984<\/td>\n<\/tr>\n<tr>\n<td width=\"66\">\ub2e8\uc810<\/td>\n<td width=\"631\">1. \ubaa8\ub4e0 \uc791\uc5c5\uc744 \uc218\ub3d9\uc73c\ub85c \ud558\uc5ec\uc57c \ud568<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>\uc774\uae30\uc885 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\uad00 <\/strong><strong>(ORACLE TO PostgreSQL<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>\uc11c\ub860 :<\/strong> Oracle\uc5d0\uc11c PostgreSQL\uacfc \uac19\uc740 \uc774\uae30\uc885 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc704\ud55c \uc720\ub8cc\ud234\uacfc \uc218\ub3d9 \uc774\uad00 \ubc29\ubc95\uc5d0 \ub300\ud55c \ube44\uad50<\/p>\n<p>ISPIRER , ESF, SCRIPT \uc774\uad00 \ud14c\uc2a4\ud2b8 \uc9c4\ud589<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\ud14c\uc2a4\ud2b8 :<\/strong> 1. ORACLE 1.8G (SHPP_CUST) \uc758 \ub370\uc774\ud130\ub97c PostgreSQL\ub85c \uc774\uad00 (\uc778\ub371\uc2a4, \ud568\uc218 ,\ud391\uc158) \uc18d\ub3c4 \ube44\uad50<\/p>\n<ol start=\"2\">\n<li>\uc774\uad00 \uc2dc \uc18d\ub3c4 \ube44\uad50<\/li>\n<li>LOB \ub370\uc774\ud130 \uc774\uad00 \uc18d\ub3c4 \ube44\uad50 (LOB_TAB)<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>\uacb0\ub860 :<\/strong> ISPIRER\uc774 \uc218\ub3d9\uc73c\ub85c \uc774\uad00\ud558\ub294 SCRIPT \ubc29\uc2dd\uacfc \uc18d\ub3c4\uba74\uc5d0\uc11c \ucc28\uc774\uac00 \uc5c6\uc73c\uba70, \uc9c1\uad00\uc801\uc778 UI\ub85c \uc0ac\uc6a9\uc790 \ud3b8\uc758\uc131\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e8\uac00\ub9cc \uad1c\ucc2e\ub2e4\uba74 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \uc0ac\uc6a9\ud558\uc5ec\ub3c4 \uc88b\uc740 \uc194\ub8e8\uc158 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p>SCRIPT \uc774\uad00\uc740 \uc0ac\uc6a9\uc790\uc758 SCRIPT \uc791\uc131\uc774 \ubd88\ud3b8\ud558\uc9c0\ub9cc, \uc18d\ub3c4\uba74\uc5d0\uc11c\ub294 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ucd94\uac00\uc801\uc778 \ub2e8\uc810\uc740 LOB \ub370\uc774\ud130 \uad00\ub828 \uc5d0\ub7ec\uac00 \ub098\uba74 \uc81c\uc870\uc0ac\uc5d0 \uc694\uccad\ud574\uc11c \ud574\uacb0\ub41c \uc124\uce58\ud30c\uc77c\uc744 \ub2e4\uc2dc \uc124\uce58 \ud574\uc11c \uc9c4\ud589\uc744 \ud558\uc5ec\uc57c \ud568<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\ud14c\uc2a4\ud2b8 \ube44\uad50 \uc790\ub8cc<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"236\">\uc81c\ud488 \/ \ub0b4\uc5ed<\/td>\n<td width=\"151\">\uc774\uad00<\/td>\n<td width=\"113\">ISPIRER<\/td>\n<td width=\"104\">ESF<\/td>\n<td width=\"93\">SCRIPT<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"236\">\ub370\uc774\ud130 \uc774\uad00\ubc29\uc2dd<\/td>\n<td width=\"151\">\ub370\uc774\ud130 \ub2e4\uc6b4\ub85c\ub4dc<\/td>\n<td width=\"113\">EXPORT<\/td>\n<td width=\"104\">EXPORT<\/td>\n<td width=\"93\">LODER<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">\ub370\uc774\ud130 \uc5c5\ub85c\ub4dc<\/td>\n<td width=\"113\">LODER<\/td>\n<td width=\"104\">LODER<\/td>\n<td width=\"93\">LODER<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"236\">TABLE 1.8G\uc774\uad00\/LOB \uc18d\ub3c4<\/td>\n<td width=\"151\">\ub370\uc774\ud130 \ub2e4\uc6b4\ub85c\ub4dc<\/td>\n<td width=\"113\">5m<\/td>\n<td width=\"104\">5m<\/td>\n<td width=\"93\">5m<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">\ub370\uc774\ud130 \uc5c5\ub85c\ub4dc<\/td>\n<td width=\"113\">4m 02s<\/td>\n<td width=\"104\">3hr 33m<\/td>\n<td width=\"93\">3m 50s<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\uc5b8\uc5b4\uc774\uad00 (\ud55c\uae00 \uc22b\uc790 \uc601\uc5b4 \ub4f1)<\/td>\n<td rowspan=\"5\" width=\"151\">&nbsp;<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">O<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">Function ,trigger,<\/p>\n<p>procedure, view \uc790\ub3d9\uc774\uad00 \uc5ec\ubd80<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">X<\/td>\n<td width=\"93\">X<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\uc774\uad00 \uc5d0\ub7ec \uc2dc \ud655\uc778 \uc5ec\ubd80<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">O<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\ucee4\uc2a4\ud140 \uc5ec\ubd80 (UI, SCRIPT\uc218\uc815)<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">X<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"236\">\ud0c0 \uc774\uae30\uc885 \uc9c0\uc6d0 \uc5ec\ubd80<\/td>\n<td width=\"113\">O<\/td>\n<td width=\"104\">O<\/td>\n<td width=\"93\">O<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>\ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc0c1\uc6a9TOOL<\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<ul>\n<li><strong>\ub9ce\uc774<\/strong> <strong>\uc0ac\uc6a9\ud558\ub294<\/strong> <strong>\ud234<\/strong> <strong>(<\/strong><strong>\uc18d\ub3c4\uac00<\/strong> <strong>script <\/strong><strong>\uc640<\/strong> <strong>\ube44\uc2b7\ud55c<\/strong> <strong>\uc815\ub3c4\ub85c<\/strong> <strong>\ube60\ub978<\/strong> <strong>tool)<\/strong><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"226\"><strong>\uc885\ub958<\/strong><\/td>\n<td width=\"471\"><strong>\ube44\uace0<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"226\">Ispirer (SQL WAY) :<\/td>\n<td width=\"471\"><a href=\"http:\/\/www.ispirer.com\/products\/oracle-to-mysql-migration\">http:\/\/www.ispirer.com\/products\/oracle-to-mySQL-migration<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"226\">Oracle2pg<\/td>\n<td width=\"471\"><a href=\"https:\/\/www.postgresql.org\/about\/news\/1459\/\">https:\/\/www.postgresql.org\/about\/news\/1459\/<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"226\">Ppas (lockplace)<\/td>\n<td width=\"471\">\ub2e4\uc6b0\uae30\uc220\uc5d0\uc11c \ub9cc\ub4e0 \ud234 (\ucd5c\uadfc\uc5d0 \uc0ac\uc6a9\ub418\uae30 \uc2dc\uc791\ud55c tool)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>\uc77c\ubc18\uc801\uc73c\ub85c\ub294<\/strong> <strong>\uc0ac\uc6a9<\/strong> <strong>\ub418\ub098<\/strong> <strong>\uc18d\ub3c4\uac00<\/strong> <strong>\ub290\ub9b0<\/strong> <strong>tool<\/strong><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"226\"><strong>\uc885\ub958<\/strong><\/td>\n<td width=\"471\"><strong>\ube44\uace0<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"226\">Dbconvert :<\/td>\n<td width=\"471\">\uc77c\ubc18\uc801\uc778 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud234 (\uc18d\ub3c4\uac00 \ub290\ub9ac\ub2e4)<\/td>\n<\/tr>\n<tr>\n<td width=\"226\">SQLLINE :<\/td>\n<td width=\"471\"><a href=\"http:\/\/www.sqlines.com\/oracle-to-postgresql-tool\">http:\/\/www.sqlines.com\/oracle-to-postgresql-tool<\/a> (\uc18d\ub3c4\uac00 \ub290\ub9ac\ub2e4)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>\u00a0<\/strong><\/p>\n<ul>\n<li><strong>\uc0ac\uc6a9\ub418\ub294<\/strong> <strong>\uc815\ubcf4\ub294<\/strong> <strong>\uc5c6\uc73c\ub098<\/strong><strong>, <\/strong><strong>\ub9c8\uc774\uadf8\ub808\uc774\uc158\uc774<\/strong> <strong>\uac00\ub2a5\ud55c<\/strong> <strong>tool<\/strong><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"226\"><strong>\uc885\ub958<\/strong><\/td>\n<td width=\"471\"><strong>\ube44\uace0<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"226\"><strong>2ndQuadrant<\/strong><\/td>\n<td width=\"471\"><strong>:<\/strong><a href=\"https:\/\/www.2ndquadrant.com\/en\/services\/migrate-from-oracle-to-postgresql\/\">https:\/\/www.2ndquadrant.com\/en\/services\/migrate-from-oracle-to-postgresql\/<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"226\">ENTERPRISEDB<\/td>\n<td width=\"471\"><a href=\"https:\/\/www.enterprisedb.com\/ko\/edb-postgres-migration-toolkit\">https:\/\/www.enterprisedb.com\/ko\/edb-postgres-migration-toolkit<\/a><\/td>\n<\/tr>\n<tr>\n<td width=\"226\">DBCONF<\/td>\n<td width=\"471\">\ud655\uc778 \ud544\uc694<\/td>\n<\/tr>\n<tr>\n<td width=\"226\">Nttsoft<\/td>\n<td width=\"471\">\uc77c\ubcf8\ud68c\uc0ac\uc5d0\uc11c \ub9cc\ub4e0 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud234 (\ub9ce\uc740 \uc815\ubcf4\uac00 \uc5c6\uc74c)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ISPIRER \uc740 \uc218\ub3d9\uc73c\ub85c \ud558\ub294 SCRIPT \uc791\uc5c5\uc744 \ud1b5\ud55c \uc774\uad00\uacfc \uc2dc\uac04\ucc28\uc774\uac00 \uac70\uc758 \ub098\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. (1\ub2ec \ub370\ubaa8 \uc0ac\uc6a9) \ub610\ud55c \ucee8\ubc84\ud2b8 \uc2a4\ud06c\ub9bd\ud2b8 \ub610\ud55c \uc815\ud655\ud558\uac8c \ubcc0\ud658\uc774 \ub418\uc5b4 \uc791\uc5c5\uc790\uc758 \uc791\uc5c5 \ub2a5\ub960 \ubc0f \ud3b8\uc758\uc131\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uac00\uaca9 \ub2e8\uac00\ub294 \uc5c5\uccb4\uc640 \ud611\uc758\ub97c \ud558\uc5ec\uc57c \ub418\ub294 \uac78\ub85c \uc54c\uace0 \uc788\uc73c\uba70, 1\ubc88 \uad6c\uc785\ud558\uba74 \ud3c9\uc0dd \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc544\ub2cc \uae30\uac04 \ub2e8\uc704\ub85c \uacc4\uc57d\uc744 \ud558\uc5ec\uc57c \ub418\ub294 \uac83\uc73c\ub85c \ucd94\uc815 \ub429\ub2c8\ub2e4. \u00a0 ESF \uc740 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[21],"tags":[1160,1159,1148,1147,1143,1144],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Epi-194-M2M.jpg?fit=425%2C282","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4517"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4517"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4517\/revisions"}],"predecessor-version":[{"id":4518,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4517\/revisions\/4518"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3406"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4517"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}