TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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?
Reply
Answers (
1
)
Compare condition in SQL server.
how to insert images in a database