cschmid
asked on
Oracle SQL DTS
Hi,
How I can move data from Oracle to MS-SQL?
My first idea are use DTS from MS SQL, but I cant stablish the communication between servers.
The TNSNames.ora is like:
MYSERV.AM.BOEHRINGER.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SRV1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = INFO1)
)
)
Can you explain me how I can stablish a connection from a DTS?
How I can move data from Oracle to MS-SQL?
My first idea are use DTS from MS SQL, but I cant stablish the communication between servers.
The TNSNames.ora is like:
MYSERV.AM.BOEHRINGER.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SRV1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = INFO1)
)
)
Can you explain me how I can stablish a connection from a DTS?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.