Skip to Main Content
  • Questions

  • DB migration - SQL Server - Oracle 12c

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ganesh.

Asked: May 04, 2016 - 5:56 am UTC

Last updated: May 04, 2016 - 11:34 am UTC

Version: oracle 12c

Viewed 1000+ times

You Asked

Hi Tom,

Which is the best way to migrate a DB from MS SQL server to Oracle 12c?
I can see couple of sources for that from some forums but still unclear with that.
Please help on this.

Thanks in advance.

and Connor said...

Some good documentation on the tools here

http://www.oracle.com/technetwork/topics/migration-101800.html

and a nice blog post with a demo from Jeff Smith, on how you can integrate this with SQL Developer

http://www.thatjeffsmith.com/archive/2011/06/moving-data-to-oracle-with-migration-workbench/

http://www.thatjeffsmith.com/archive/2012/01/sql-developer-supports-db2-sybase-mysql-access-and-teradata/

http://www.slideshare.net/hillbillyToad/oracle-sql-developer-for-sql-server

If you had a huge amount of data to migrate, then you could also consider GoldenGate for the task.

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks for the Quick response..!!!

Ganesh Kumar, May 04, 2016 - 8:32 am UTC

It's more valuable..... Thanks Conor...

Thanks for visiting India last month.....By next time I hope ,I will get a chance to meet you..


Connor McDonald
May 04, 2016 - 11:34 am UTC

I hope to be back.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.