Database Migration with Oracle
Moving data physically from a SQL Server or Microsoft Access database to an Oracle Database Server is a relatively simple process. The free SQL Developer tool provides substantial capabilities for modelling the metadata and transferring data. Stored Procedures can also be translated into Oracle's PL/SQL language.
Migrating an existing application to Oracle Database Server requires an understanding of Oracle's unique features. For example, the locking and concurrency model ensures readers and writers of data do not block each other - and yet data is always presented in a transactionally consistent form. The result is that some application code that attempted to work around scalability issues can be amended to a simpler and more natural expression of the business need.
Oracle provides many resources to assist in migrating ISV solutions, including a specialist centre in the UK where advice and porting facilities can be exploited to assist in optimising the process. Please use the menu to the left to access articles, tutorials and other information about migration.
Facilities
Oracle has a number of facilities and laboratories for partners to use for demonstration, proof of concept and migration purposes. These include the Enterprise Technology Centre and the Partner Technology Centre.
Migration Resource Centre for Microsoft ISVs
Microsoft ISVs with their .NET based applications and running on SQL Server can reduce the time and cost to migrate their apps on rich Oracle database stacks to exploit enterprise functionality with comprehensive and rich set of products and solutions offering from Oracle. These solutions will enable .NET based apps to enterprise class using Real Application Cluster technology for higher availability and reliability.
Oracle offers a range of migration services to its partners to help you optimize your usage of Oracle technology. These services include best practices, tools, and documents.
Go to: Migration Resource Centre for Microsoft ISVs