Hello All, does the migration from MS SQL Server to oracle is a straight forward , I mean importing oracle database tables to MS SQL Server database on the database level, or the structure of the database created by data objects is difference?.

We have a customer that request to work on oracle, but we think to ask him to work on SQL Server till we test oracle database on our application, then migrate data.


asked Sep 23 '14 at 05:04

ahmad%20emad's gravatar image

ahmad emad

One Answer:

Hello Ahmad.

Dataobjects tries to create the same database model as much as possible. However, every RDBMS has its own types, features, rules and conventions and DO must take into account object names, types and other aspects of concrete RDBMS. If you want to use some migration tool then I can't guaranty that database schema will be exact the same as created by DataObjects. Also DO creates some metadata information and you must make sure that it'll migrate too.

I think you can migrate from MS SQL Server to Oracle and back, but you may face with some problems depends on your case.

answered Sep 23 '14 at 09:19

Alexey%20Kulakov's gravatar image

Alexey Kulakov

Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

powered by OSQA