2.1 The Migration Process

Table of Contents Previous Next


2 Migration Methodology : 2.1 The Migration Process

2.
Identify potential migration problems. If it is an Oracle-to-Advanced Server migration, consult the Database Compatibility for Oracle® Developer's Guide for complete details about the compatibility features supported in Advanced Server. Consider using EnterpriseDB's migration assessment service to assist in this review.
If your data has BLOB or CLOB data, use the dblink_ora style database links instead of the Oracle style database links.
Use Dynatune to dynamically adjust database configuration resources.
Use Optimizer Hints to direct the query path.
Use the ANALYZE command to retrieve database statistics.
The EDB Postgres Advanced Server Guide and Database Compatibility for Oracle Developer's Guide (both available through the EnterpriseDB website) offer information about the performance tuning tools available with Advanced Server.

2 Migration Methodology : 2.1 The Migration Process

Table of Contents Previous Next