SQL Server Migration Assistant For Oracle 2017 05

SQL Server Migration Assistant For Oracle 2017. 05. 30 김태용

Description 마이그레이션 프로젝트 생성 1 마이그레이션 프로그램 실행 2 프로젝트 생성 3 마이그레이션 할 서버 선택 • SQL Server Migration Assatant For Oracle • https: //docs. microsoft. com/en-us/sql/ssma/sql-server-migrationassistant • Oracle SQL Developer • https: //docs. microsoft. com/en-us/sql/ssma/sql-server-migrationassistant • Microsoft SQL Server Management Studio • https: //msdn. microsoft. com/ko-kr/library/mt 238290. aspx

Description 1 MSSQL 스키마 변경(XXX-> dbo) ALTER ALTER ALTER ALTER ALTER SCHEMA SCHEMA SCHEMA SCHEMA SCHEMA dbo dbo dbo dbo dbo TRANSFER TRANSFER TRANSFER TRANSFER TRANSFER SIMPLE. IDS SIMPLE. LETTCCMMNCLCODE SIMPLE. LETTCCMMNDETAILCODE SIMPLE. LETTNAUTHORGROUPINFO SIMPLE. LETTNBBSMASTEROPTN SIMPLE. LETTNBBSUSE SIMPLE. LETTNEMPLYRINFO SIMPLE. LETTNENTRPRSMBER SIMPLE. LETTNFILEDETAIL SIMPLE. LETTNGNRLMBER SIMPLE. LETTNORGNZTINFO SIMPLE. LETTNSCHDULINFO SIMPLE. LETTNTMPLATINFO SIMPLE. COMVNUSERMASTER 2 1 생성된 쿼리를 수행하면 스키마 변환 끝 2 수행직후 새로고침하면, 정상적으로 dbo 로 스키마가 변 경됨. 3 4 5