?
Solved

Oracle to SQL Server

Posted on 2013-10-23
1
Medium Priority
?
367 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 2000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

765 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