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