SQL Server Migration Assistant from Oracle 8.0.5 to SQL Server 2005 RRS feed

  • Question

  • Hi my name is Yohanes. Im a newbie in oracle.

    I am going to migrate my data from Oracle 8.0.5 (old server) to SQL Server 2005 (new server) for my final year project in university.
    I am using "SQL Server Migration Assistant for ORacle" Tools from Micosoft website.

    But there is an error message
    OleDB provider "OraOLEDB.Oracle" for linked server "" returned message "ORA-12154: TNS:could not resolve service name". is the IP address of old server.

    how do we know the service name for oracle?

    Do you have any suggestion?
    Thanks for the advice..

    Wednesday, August 15, 2007 10:26 AM


  • On the Oracle server, check the instance name in the Control Panel "Services" Applet. Also, never publish your TCP/IP address for your server on the web - we don't want the bad guys to break in!


    Buck Woody

    SQL Server Team

    Wednesday, August 15, 2007 3:33 PM