?
Solved

Oracle to SQL Server Migration

Posted on 1998-09-28
3
Medium Priority
?
177 Views
Last Modified: 2010-03-19
The Databases created by Oracle should be converted to a form understood by SQL Server so that it can access these Databases. How do I go about it?
0
Comment
Question by:rissamceo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Expert Comment

by:tomook
ID: 1090301
I understand SQL Server can use ODBC links to Oracle tables. I think SQL 7 can do it better, but I have no direct experience. I have used Access to translate between the two before, and for a one-time shot it works pretty well, as long as the data is not GB or TB.
0
 
LVL 7

Accepted Solution

by:
spiridonov earned 600 total points
ID: 1090302
I do not know about any free tools,but if you are prepared to pay, I sould suggest looking at Logic Works ErWin software,which allows you to convert data models from one DB type to another. It helped me a lot, when I was doing a conversion from Dbase to SQL. As for the data , the quickest way to import data into SQL Server is by using text files and bcp.
0
 

Author Comment

by:rissamceo
ID: 1090303
Please post any more helpful  tips
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question