Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Venkat.

Asked: October 14, 2016 - 10:42 am UTC

Last updated: October 14, 2016 - 1:24 pm UTC

Version: 119

Viewed 1000+ times

You Asked

i have database in sql server 2008, now i want to migrate whole databse from sql server 2008 to oracle 11g.
my question is how to migrate the sql server database into oracle 11g?

and Chris said...

Migrating between database vendors can be tough. All have their own subtle differences in how they work. You'll need to check your application thoroughly and update as needed.

The following video series does a great job of explaining some of the things you'll need to watch for:

https://www.youtube.com/playlist?list=PLfIMjyfW_SqoBr6YFJpZ7cx86xTWi0ghx

If you're looking for a process to move the data, check out the migration tool in SQL Developer:

http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html

Is this answer out of date? If it is, please let us know via a Comment
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.