{"id":4405,"date":"2019-02-01T15:13:09","date_gmt":"2019-02-01T06:13:09","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4405"},"modified":"2019-02-01T15:13:09","modified_gmt":"2019-02-01T06:13:09","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","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4405","title":{"rendered":"\uc774\uae30\uc885 \ub9c8\uc774\uadf8\ub808\uc774\uc158 TOOL"},"content":{"rendered":"

\uc885\ud569\uacb0\ub860<\/span><\/b><\/p>\n

 <\/p>\n

ISPIRER<\/span><\/b> <\/b>\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)<\/span><\/p>\n

\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.<\/span><\/p>\n

\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.<\/span><\/p>\n

\u00a0<\/span><\/p>\n

ESF<\/span><\/b> <\/b>\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)<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\uc218\ub3d9(<\/span><\/b>SCRIPT)<\/b>\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.\u00a0<\/span>\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.<\/span><\/p>\n

\u00a0<\/span>\u00a0<\/span><\/p>\n

\uc774\uae30\uc885 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/span><\/b> <\/b>\uc774\uad00 <\/b>(ORACLE TO <\/b>M<\/b>Y <\/b>SQL<\/b><\/span>)<\/span><\/b><\/p>\n

\u00a0<\/span><\/p>\n

\uc11c\ub860
\n<\/span><\/b><\/p>\n

Oracle\uc5d0\uc11c MySQL\uacfc \uac19\uc740 \uc774\uae30\uc885 <\/span>\ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc704\ud55c \uc720\ub8cc \ud234\uacfc \uc218\ub3d9 \uc774\uad00 \ubc29\ubc95\uc5d0 \ub300\ud55c \ube44\uad50\u00a0<\/span>ISPIRER , ESF, SCRIPT \uc774\uad00 \ud14c\uc2a4\ud2b8 \uc9c4\ud589<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\ud14c\uc2a4\ud2b8<\/span><\/b><\/p>\n


\n<\/span><\/b> 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<\/span><\/p>\n

2. \uc774\uad00 \uc2dc \uc18d\ub3c4 \ube44\uad50<\/span><\/p>\n

3. LOB \ub370\uc774\ud130 \uc774\uad00 \uc18d\ub3c4 \ube44\uad50 (LOB_TAB)<\/span><\/p>\n

 <\/p>\n

\uacb0\ub860<\/span><\/b><\/p>\n


\n<\/span><\/b> 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.<\/span><\/p>\n

\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.<\/span><\/p>\n

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.
\n<\/span><\/p>\n

\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<\/span><\/p>\n

\n

\ud14c\uc2a4\ud2b8<\/span><\/b>\ube44\uad50 \uc790\ub8cc<\/span><\/b><\/p>\n

 <\/p>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n
\n

\uc81c\ud488 \/ \ub0b4\uc5ed<\/span><\/p>\n<\/td>\n

\n

\uc774\uad00<\/span><\/p>\n<\/td>\n

\n

ISPIRER<\/span><\/p>\n<\/td>\n

\n

ESF<\/span><\/p>\n<\/td>\n

\n

SCRIPT<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\ub370\uc774\ud130
\n\uc774\uad00\ubc29\uc2dd<\/span><\/p>\n<\/td>\n

\n

\ub370\uc774\ud130
\n\ub2e4\uc6b4\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

\n

EXPORT<\/span><\/p>\n<\/td>\n

\n

EXPORT<\/span><\/p>\n<\/td>\n

\n

LODER<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\ub370\uc774\ud130
\n\uc5c5\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

\n

LODER<\/span><\/p>\n<\/td>\n

\n

LODER<\/span><\/p>\n<\/td>\n

\n

LODER<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

TABLE
\n1.8G\uc774\uad00\/LOB \uc18d\ub3c4<\/span><\/p>\n<\/td>\n

\n

\ub370\uc774\ud130
\n\ub2e4\uc6b4\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

\n

5m<\/span><\/p>\n<\/td>\n

\n

5m<\/span><\/p>\n<\/td>\n

\n

5m<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\ub370\uc774\ud130
\n\uc5c5\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

\n

4m
\n42s<\/span><\/p>\n<\/td>\n

\n

2hr
\n33m<\/span><\/p>\n<\/td>\n

\n

4m
\n18s<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\uc5b8\uc5b4\uc774\uad00
\n(\ud55c\uae00 \uc22b\uc790, \uc601\uc5b4 \ub4f1)<\/span><\/p>\n<\/td>\n

\n

\u00a0<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Function
\n,trigger, <\/span><\/p>\n

procedure,
\nview \uc790\ub3d9\uc774\uad00 \uc5ec\ubd80<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

X<\/span><\/p>\n<\/td>\n

\n

X<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\uc774\uad00
\n\uc5d0\ub7ec \uc2dc \ud655\uc778 \uc5ec\ubd80<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\ucee4\uc2a4\ud140
\n\uc5ec\ubd80 (UI, SCRIPT\uc218\uc815)<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

X<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\ud0c0
\n\uc774\uae30\uc885 \uc9c0\uc6d0 \uc5ec\ubd80<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n

\n

O<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/p>\n

    \n
  1. \n

    \ucc38\uc870\u00a0<\/span><\/b>\uc0ac\uc774\ud2b8 <\/b>:<\/b><\/span> <\/b><\/p>\n<\/li>\n<\/ol>\n

    http:\/\/www.SQLines.com\/oracle-to-mySQL<\/span><\/a> (\ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \uc774\uc288, \ub808\ud37c\ub7f0\uc2a4 \ub4f1 \ube44\uad50)<\/span><\/p>\n

    \u00a0<\/span><\/p>\n

      \n
    1. \n

      \ud55c\uad6d \ub0b4 \uad50\uc721\ud574\uc8fc\ub294 <\/span><\/b>\uc5c5\uccb4<\/b> :
      \n<\/span><\/p>\n<\/li>\n<\/ol>\n

      https:\/\/estudy.kitri.re.kr\/usrs\/eduRegMgnt\/eduRegInfoDetailForm.do?p_crscd=441&p_crsseq_id=335&p_view_type=&CRSCD=&CRSSEQ_ID=335&p_ctgrycd=3000&p_hmpgcd=32&mkey=47794&p_srch_year=2018<\/span><\/a><\/p>\n

      \u00a0<\/span><\/p>\n

        \n
      1. \n

        \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc0c1\uc6a9T<\/span><\/b>OOL<\/span><\/b><\/p>\n<\/li>\n<\/ol>\n

        Ispirer\u00a0<\/span><\/b>(<\/b>SQL<\/b> WAY<\/b>)<\/b> : <\/span><\/span>http:\/\/www.ispirer.com\/products\/oracle-to-mySQL-migration<\/span><\/span><\/a><\/p>\n

        \n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/span><\/span><\/p>\n

        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\u00a0<\/span><\/span>\uc774\uad00\ud574 \uc90c<\/span><\/p>\n

        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
        \n<\/span><\/span><\/p>\n

        4. \uc18d\ub3c4\uac00 \ube60\ub984 <\/span><\/span><\/p>\n

        5. \uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        \uac00\uaca9\uc774 \ube44\uc308<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        \u00a0<\/span><\/p>\n

        E<\/span><\/b>SF<\/b> <\/b>DMT<\/b> :<\/b><\/span> <\/b><\/span><\/p>\n

        \n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/span><\/span><\/p>\n

        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<\/span><\/span><\/p>\n

        3.\uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/span><\/span><\/p>\n

        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)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        DBLoader\u00a0<\/span><\/b>:<\/b> <\/b><\/span><\/span>http:\/\/<\/b>www.dbload.com<\/b><\/span>\/<\/span><\/b><\/span><\/a><\/p>\n

        \n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/span><\/span><\/p>\n

        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)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        DBCONVERT<\/span><\/b> :<\/b><\/span>\u00a0http:\/\/<\/span><\/b>dbconvert.com<\/b>\/convert-oracle-to-<\/b>my<\/b>SQL<\/b>–<\/b><\/span>pro.php<\/span><\/b><\/span><\/a><\/p>\n

        \n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n
          \n
        1. \n

          \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/span><\/span><\/p>\n<\/li>\n

        2. \n

          \uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/span><\/span><\/p>\n<\/li>\n<\/ol>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/span><\/span><\/p>\n

        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
        \n\ud568)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        S<\/span><\/b>pactral<\/b> <\/b>Core :<\/b><\/span> <\/b>http:\/\/<\/span><\/b>www.spectralcore.com<\/b>\/<\/b>omegasync<\/b><\/span>\/<\/span><\/b><\/span><\/a><\/p>\n

        \n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2dc \ub370\uc774\ud130\ub97c \uc790\ub3d9 \ubcc0\ud658\ud574 \uc90c<\/span><\/span><\/p>\n

        2 .\uac70\uc758 \ubaa8\ub4e0 \uc774\uae30\uc885DB \uac00\ub2a5<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/span><\/span><\/p>\n

        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)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        \u00a0<\/span><\/p>\n

        \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ubb34\ub8cc T<\/span><\/b>OOL<\/span><\/b><\/p>\n

         <\/p>\n

        SQL<\/span><\/b>developer<\/b> :<\/b> <\/b><\/span>\uc624\ub77c\ud074 \uc804\uc6a9 \ud234<\/span><\/b><\/p>\n

         <\/p>\n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        \uc5c6\uc74c<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/span><\/span><\/p>\n

        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\u00a0 \ud568)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        my<\/span><\/b>SQL<\/b> <\/b>workbench<\/b> :<\/b><\/span>\u00a0https:\/\/<\/b>dev.my<\/b>SQL<\/b>.com<\/b><\/span>\/downloads\/workbench\/<\/span><\/b><\/a><\/p>\n

         <\/p>\n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1.MYSQL \uc804\uc6a9 \uc774\uad00 \ud234<\/span><\/p>\n

        2.UI\uac00 \uc9c1\uad00\uc801\uc784<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \uc18d\ub3c4\uac00 \ub290\ub9bc<\/span><\/span><\/p>\n

        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)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        \uc2a4\ud06c\ub9bd\ud2b8 \uc774\uad00<\/span><\/b><\/p>\n\n\n\n<\/colgroup>\n\n\n\n
        \n

        \uc7a5\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. \ub370\uc774\ud130 \uc774\uad00\uc774 \ube60\ub984<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub2e8\uc810<\/span><\/span><\/p>\n<\/td>\n

        		\n

        1. <\/span><\/span>\ubaa8\ub4e0 \uc791\uc5c5\uc744 \uc218\ub3d9\uc73c\ub85c \ud558\uc5ec\uc57c \ud568<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        \uc774\uae30\uc885 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/span><\/b> <\/b>\uc774\uad00 <\/b>(ORACLE TO Postgre<\/b><\/span>SQL )<\/span><\/b><\/p>\n

        \u00a0<\/span><\/p>\n

        \uc11c\ub860
        \n<\/span><\/b><\/p>\n

        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<\/span><\/p>\n

        ISPIRER , ESF, SCRIPT \uc774\uad00 \ud14c\uc2a4\ud2b8 \uc9c4\ud589<\/span><\/p>\n

        \u00a0<\/span><\/p>\n

        \ud14c\uc2a4\ud2b8
        \n<\/span><\/b><\/p>\n

        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<\/span><\/p>\n

        2. \uc774\uad00 \uc2dc \uc18d\ub3c4 \ube44\uad50<\/span><\/p>\n

        3. LOB \ub370\uc774\ud130 \uc774\uad00 \uc18d\ub3c4 \ube44\uad50 (LOB_TAB)<\/span><\/p>\n

         <\/p>\n

         <\/p>\n

        \uacb0\ub860
        \n<\/span><\/b><\/p>\n

        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.<\/span><\/p>\n

        \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.\u00a0<\/span>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.<\/span><\/a><\/p>\n

        <\/a><\/p>\n

        \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<\/span><\/p>\n

        \u00a0<\/span><\/p>\n

        \ud14c\uc2a4\ud2b8 \ube44\uad50 \uc790\ub8cc<\/span><\/b><\/p>\n

         <\/p>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n
        \n

        \uc81c\ud488 \/ \ub0b4\uc5ed<\/span><\/p>\n<\/td>\n

        		\n

        \uc774\uad00<\/span><\/p>\n<\/td>\n

        		\n

        ISPIRER<\/span><\/p>\n<\/td>\n

        		\n

        ESF<\/span><\/p>\n<\/td>\n

        		\n

        SCRIPT<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub370\uc774\ud130 \uc774\uad00\ubc29\uc2dd<\/span><\/p>\n<\/td>\n

        		\n

        \ub370\uc774\ud130 \ub2e4\uc6b4\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

        		\n

        EXPORT<\/span><\/p>\n<\/td>\n

        		\n

        EXPORT<\/span><\/p>\n<\/td>\n

        		\n

        LODER<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub370\uc774\ud130 \uc5c5\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

        		\n

        LODER<\/span><\/p>\n<\/td>\n

        		\n

        LODER<\/span><\/p>\n<\/td>\n

        		\n

        LODER<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        TABLE 1.8G\uc774\uad00\/LOB \uc18d\ub3c4<\/span><\/p>\n<\/td>\n

        		\n

        \ub370\uc774\ud130 \ub2e4\uc6b4\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

        		\n

        5m<\/span><\/p>\n<\/td>\n

        		\n

        5m<\/span><\/p>\n<\/td>\n

        		\n

        5m<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ub370\uc774\ud130 \uc5c5\ub85c\ub4dc<\/span><\/p>\n<\/td>\n

        		\n

        4m
        \n02s<\/span><\/p>\n<\/td>\n

        		\n

        3hr
        \n33m<\/span><\/p>\n<\/td>\n

        		\n

        3m
        \n50s<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \uc5b8\uc5b4\uc774\uad00 (\ud55c\uae00 \uc22b\uc790 \uc601\uc5b4 \ub4f1)<\/span><\/p>\n<\/td>\n

        		\n

        \u00a0<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        Function ,trigger,\u00a0<\/span>procedure,\u00a0<\/span>view \uc790\ub3d9\uc774\uad00 \uc5ec\ubd80<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        X<\/span><\/p>\n<\/td>\n

        		\n

        X<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \uc774\uad00 \uc5d0\ub7ec \uc2dc \ud655\uc778 \uc5ec\ubd80<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ucee4\uc2a4\ud140 \uc5ec\ubd80 (UI, SCRIPT\uc218\uc815)<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        X<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n<\/tr>\n

        \n

        \ud0c0 \uc774\uae30\uc885 \uc9c0\uc6d0 \uc5ec\ubd80<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n

        		\n

        O<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u00a0<\/span><\/p>\n

        \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc0c1\uc6a9T<\/span><\/b>OOL<\/span><\/b><\/p>\n

        \u00a0<\/span><\/p>\n