oracle的表导入sqlsever,如何将oracle 中的表定时自动导入sqlserver

(SID_DESC =

[B](PROGRAM = tg4msql)[/B]

(SID_NAME = tg4msql)

(ORACLE_HOME = D:\oracle\ora92)

)[/COLOR]

)

$ORACEL_HOME\network\admin\tnsnames.ora

内容如下：

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

NORTHWIND.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = TEST)(PORT = 1521))

)

(CONNECT_DATA =

(SID = tg4msql)

)

[B](HS = OK)[/B]

)[/COLOR]

ORA92.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = TEST)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ora92.localdomain)

)

)

INST1_HTTP.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = TEST)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = MODOSE)

(PRESENTATION = http://HRService)

)

)

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)