Oracle to SQL Server

Hi, we are moving database from Oracle to SQL Server 2008.
What are our options?

Thank you in advance.
quasar_eeAsked:
Who is Participating?
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.