Oracle to SQL Server

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

Thank you in advance.
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):

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).
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.