[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

Oracle to SQL Server Migration

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
rissamceo
Asked:
rissamceo
1 Solution
 
tomookCommented:
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
 
Victor SpiridonovCommented:
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
 
rissamceoAuthor Commented:
Please post any more helpful  tips
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now