# Can My Oracle Database Migrate?


To quickly see if your workload qualifies as a migration candidate, please use the **DMA Connect Application and Database Questionnaire** to sort out migration obstacles specific to your application. Consider the following questions. The more you answer **No**, the easier the migration to Amazon RDS for PostgreSQL or Aurora PostgreSQL will be.


| Application Questions | Comments | 
| --- | --- | 
|  Are there Oracle dependent parts of the application that you can’t modify by yourself?  |  If you don’t control all of the code it can be difficult to change the underlying database.  | 
|  Is the application commercial off the shelf, and not available for PostgreSQL?  |  Unless the commercial off-the shelf software (COTS) application also supports PostgreSQL, it will not be able to migrate.  | 
|  Does the application use specific methods to connect to an Oracle database such as Oracle Call Interface (OCI)?  |  Refactoring OCI calls to ODBC is not impossible, but typically an involved process.  | 
|  Does the application use Oracle specific libraries?  |  It could be challenging finding PostgreSQL replacements for Oracle specific libraries.  | 


| Database Questions | Comments | 
| --- | --- | 
|  Does the database use any third party packages?  |  It could be challenging finding PostgreSQL replacements for Oracle specific packages.  | 
|  Does the database use any data cartridges?  |  It could be challenging finding PostgreSQL replacements for Oracle specific cartridges.  | 
|  Does the application use Oracle Forms or Application Express (APEX)?  |  Completely replacing Forms or APEX with a non-Oracle solution is substantial.  | 
|  Does the database use SQLJ or .NET stored procedures?  |  You can refactor external stored procedure code for use with PostgreSQL, but it adds development work.  | 
|  Does the database use Oracle Streams?  |  Some refactoring is required to replace Oracle Streams with a PostgreSQL-compatible solution.  | 
|  Does the database use Oracle Multi Media?  |  Some refactoring is required to replace Oracle Multi Media with a PostgreSQL-compatible solution.  | 
|  Does the database use Oracle Locator?  |  Depending on feature use, such a solution may be refactored to work with PostGIS 3.1.  | 
|  Does the database use Oracle Java Virtual Machine (JVM)?  |  Detaching a Java application from Oracle JVM can be involved development work.  | 
|  Does the database use Oracle Machine Learning or formerly Advanced Analytics?  |  The solution will have to be refactored to use similar functionality on AWS.  |