Solved

Oracle to SQL Server

Posted on 2013-10-23
1
349 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
1 Comment
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now