Solved

Oracle to SQL Server

Posted on 2013-10-23
1
363 Views
Last Modified: 2013-11-05
Hi, we are moving database from Oracle to SQL Server 2008.
What are our options?

Thank you in advance.
0
Comment
Question by:quasar_ee
[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
1 Comment
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 39594548
I've done this successfully many times in the past.

I've always used the SQL Server Migration Assistant for Oracle (available for free from MS):

http://www.microsoft.com/en-us/download/details.aspx?id=28766
http://technet.microsoft.com/en-us/library/hh313179.aspx

If your database is mostly just tables without a whole bunch of PL/SQL it works very well.

It will make an attempt to translate PL/SQL to T-SQL but it will spit out lots of warnings and you'll have to manually check your code.

There may be other third party options as well for a cost (but SSMA has worked for me so I haven't looked deeply into it).
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
construct a query sql 11 38
Search Text in Views 2 25
VM SQL server license. 1 57
C# Web service insert into Oracle table 8 31
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

738 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