Olivier Muhring

Olivier Muhring

  • NA
  • 150
  • 10.1k

Importing Oracle Data into SQL Server

Nov 12 2012 7:35 PM
Gentlemen,

I suppose it's a classical problem, but still... it is rather becoming problematically.

I'm at the moment migrating a classic ASP-applicaion to ASP .NET.

The original application keeps its data in an Oracle database running on a machine somewhere. Since I'm doing most of my development @ the office, my client made a classical database dump, so I can work on my own local copy of his data.

At the office I'm working on a Windows Server 2008 R2 workstation (64 - bit), with an 64-bit version of SQL Server 2008 R2 running on it, and a 64-bit version Oracle 11g.

The 1st thing I did (logical, I know) was restoring the dump onto my own server, which was done without any difficulties. Next, I started recreating my own versions of teh tables on my SQL Server 2008 R2 database server.

When this was done I wanted to transfer the data from my Oracle database to my SQL Server database using the "import" functionality of my SQL Server Managment Studio R2.

This is as you know fairly simple, however, whenever I try to connect to my Oracle database (regardless of the Oracle connection settings I use); I keep on getting the following error:



The strange thing is: everything, from the server to the client are 64-bit. So, does anyone know what this means?

Answers (1)