Oracle Universal Installer → 自定義 → 選擇「Transparent Gateway」→ 選「Microsoft SQL Server」組件。
inittg4msql.ora)HS_FDS_CONNECT_INFO="SERVER=YIRONG-NO1;DATABASE=jsoct"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
可用 Migration Workbench 輔助配置（需預先建立 ODBC 系統 DSN）。
listener.ora)SID_LIST_LISTENER = (SID_LIST =
(SID_DESC = (SID_NAME=PLSExtProc)(ORACLE_HOME=...)(PROGRAM=extproc))
(SID_DESC = (GLOBAL_DBNAME=ora9i2)(ORACLE_HOME=...)(SID_NAME=ora9i2))
(SID_DESC = (GLOBAL_DBNAME=tg4msql)(PROGRAM=tg4msql)(SID_NAME=tg4msql)(ORACLE_HOME=...))
)
tnsnames.ora)TG4MSQL = (DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=tg4msql))
(HS=)
)
CREATE PUBLIC DATABASE LINK oratoSql
CONNECT TO sa IDENTIFIED BY "lanwei"
USING 'TG4MSQL';
用戶/密碼必須為 SQL Server 認證帳號。
SELECT * FROM "table_name"@oratoSql;
