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?
cschmidAsked:
Who is Participating?
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
You will need the oracle SQL Net client tools on the machine you are running MS-SQL on, then set up the TNSNames.ora on that machine and try it.  The DTS should be able to connect to the Oracle DB if the network stuff is set up correct.  I have used it in the past.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.