Home -> Products & Services -> Services -> Database Migration Service

Database Migration Service

Overview

The DB Migration Service helps clients reduce license and maintenance costs of their existing databases. Clients can save up to 80% of their Oracle DB license and maintenance costs after migrating to open-source DB solutions such as PostgreSQL.

 

Process

For clients who are heavily using Oracle functions, it is recommended to migrate to Postgres Plus Advanced Server. Migration effort to Postgres Plus Advanced Server is lesser since this DB version already supports many of the Oracle functions.

For clients who are not constrained by the Oracle functions, but still wishes to save on costs, may migrate to PostgreSQL DB.

Migration to PostgreSQL can be implemented in a number of ways. Migration can be done as a whole, which means that all functionalities are transferred to PostgreSQL. A hybrid approach can also be implemented if the some of the functionalities should remain under Oracle.

Postgres Plus Advanced Server Usage Design

Features

The DB Migration Service allows your application to run from Oracle to PostgreSQL DB without losing the original functionality of your system:

  • Common data types, functions and operators are migrated as is
  • There is high compatibility to PL/SQL
  • Oracle packages and synonyms can be used
  • Test effort is minimal since most functions are already available
  Oracle Compatible Functions of Postgres Plus Advanced Sever
  Oracle Compatible Functions of Postgres Plus Advanced Server
Data Type Support Oracle proper Data type like NUMBER, VARCHAR2
SQL Support Oracle proper SQL such as external integration
Trigger Provide a compatible trigger function
Stored Procedure Supports packages compatible with Oracle
Pro*C Provide compatible SQL pre-processor
Replication Replication from Oracle to Postgres Plus Advanced Server is available
 

Business Benefits

Migrating to an open-source DB solution lets you have significant savings. You can save up to 80% on your DB licenses and maintenance costs, savings which can be used on improving existing IT systems and infrastructure.

Migrating to an open-source DB solution allows you to be flexible when making system investment decisions. Open-source DB solutions can be easily integrated with other systems. You can also avoid product lock-in to specific vendor, which often involve high licenses and maintenance costs.

Back to Top
 
  Home | About Us | Company Overview | CEO Message | Group Company | Services | Products | Careers | Inquiries
© 2009 Software Research Associates South East Asia Pte. Ltd. All rights reserved.