DB Migration 방법론및툴사용법 - :: DBguide.net

1 1DB Migration DB Migration / DB / DB 2 0. Case Company1. Migration Workflow (SQL Server, DB2 to Oracle)2. Migration 3. Migration Process Overview4. Migration Process0. Case Company1. Migration Workflow (SQL Server, DB2 to Oracle)2. Migration 3. Migration Process Overview4. Migration Process31. ISV A - 4000 , ISV .- MS SQL-Server , 05 12 1 .2. B - IBM DB2 .- DB2 .(5 )0. Case Company0. Case Company41. Migration Workflow (SQL Server, DB2 to Oracle)1. Migration Workflow (SQL Server, DB2 to Oracle)9 DB 9 9 9 Application 9 9 5(1) DBMS - O/S, ( ) - (DB LINK), DBMS - (2) Application(SQL) - SQL Server, Sybase SQL SQL - SQL (3) - DBMS - , , 2.

2 Migration 2. Migration 6- DB Capture Wizard- Migrate Wizard- DB 3. Migration Process Overview3. Migration Process Overview73. Migration Process Overview3. Migration Process Overview8 Yes No Yes Yes No Yes Multiple databases N/A N/A N/A YesN/A N/A Embedded SQL Yes N/A N/A Yes N/A Yes Groups YesNo Yes Yes YesYes ConstraintsNo YesN/A Yes YesYes Views No No N/A Yes N/A Yes Triggers No N/A N/A Yes No Yes Stored Procedures IBM DB2 UDB IBM DB2/400 MySQL Informix MS Access Sybase and SQL Server Feature 3. Migration Process Overview ( )3. Migration Process Overview ( )9 3. Migration Process Overview 3. Migration Process Overview 103. Migration Process Overview 3. Migration Process Overview 113. Migration Process Overview 3. Migration Process Overview 123.

3 Migration Process Overview 3. Migration Process Overview 1314(1) -> Migration Workbench -> 5. Migration Process5. Migration Process155. Migration Process5. Migration Process16(2) Migration Workbench Repository OK .5. Migration Process5. Migration Process17(3) OK Migration DB Capture Wizard . Next .5. Migration Process5. Migration Process18(4) Online Source Model Load -> Next 5. Migration Process5. Migration Process19(5) DB SQL Server . - sa ODBC -> Next 5. Migration Process5. Migration Process20(5) DB DB2 . - User ID , DB Name -> Next 5. Migration Process5. Migration Process21(6) -> Next 5.

4 Migration Process5. Migration Process22(7) SQL Server Oracle Model Data Type . Next .5. Migration Process5. Migration Process23(7) DB2 Oracle Model Data Type . Next .5. Migration Process5. Migration Process24(8) SQL Server/DB2 .- Yes , No .- Yes -> Next 5. Migration Process5. Migration Process25(9) .- -> Finish 5. Migration Process5. Migration Process26(10) DB 5. Migration Process5. Migration Process27(11) . OK .5. Migration Process5. Migration Process28(12) DB , , , . , Yes , No .5. Migration Process5.

5 Migration Process29(13) (SQL Server/DB2) No .- Action Create Oracle Model .5. Migration Process5. Migration Process30-Yes .5. Migration Process5. Migration Process31(14) . OK .5. Migration Process5. Migration Process32(15) , , , .- Action Migrate to Oracle .5. Migration Process5. Migration Process33-Next .5. Migration Process5. Migration Process34(16) Destination Oracle Database , , , , SID Next .5. Migration Process5. Migration Process35- Next .5. Migration Process5. Migration Process36(17) . Yse Next .5. Migration Process5. Migration Process37(18).

6 Next .5. Migration Process5. Migration Process38(19) . , Finish .5. Migration Process5. Migration Process39(20) , Create . , Ignore Error .5. Migration Process5. Migration Process40(21) OK .5. Migration Process5. Migration Process41(22) , .- , .- Reports Generation Database Migration Reports 5. Migration Process5. Migration Process42(23) Migration Workbench HTML , OK .5. Migration Process5. Migration Process43(24) , .5. Migration Process5. Migration Process445. Migration Process5. Migration Process45 !!.