Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 John Talbot (TALBJ) Sr. System Architect
Pegasystems Inc.
JP
TALBJ Member since 2010 19 posts
Posted: Mar 29, 2018
Last activity: Jul 13, 2018
Posted: 29 Mar 2018 3:45 EDT
Last activity: 13 Jul 2018 22:38 EDT
Closed
Solved

Migrating from Oracle to PostGreSQL

We have a 7.1.8 application that is currently hosted on Oracle. Customer wants to migrate this as-is to PostGreSQL, keeping the existing App Server. After scanning PDN for a couple of days it doesn't look too hard once you get past creating the DDL to build the user tables - using Data Migration Helper. Are there any papers that explain pitfalls people meet? Or can anyone who has already done this let us know what issues they ran into?

To see attachments, please log in.
Updates

Accepted Solution

Posted: 6 years ago
Posted: 12 Apr 2018 2:52 EDT
Sudhakar Reddy Yaparla (YSudhakarReddy)
JPMorgan Chase & Company

JPMorgan Chase & Company
US

Hi,

Please note that Postgresql doesn't support stored procedures. Need to convert those into functions to make it work.

To see attachments, please log in.
Posted: 6 years ago
Posted: 13 Jul 2018 22:38 EDT
george wagdy (georgew2)
SQLIE

SQLIE
EG

You can use SQLIE app 

SQLIE is used to covert from oracle to postgresql and vise vers 

You can visit  website and download the trial version 

https://www.sqlie.com/

SQLIE is also used to :

1-convert from sql server to oracle

http://www.sqlie.com/sqlie-services/convert-to-oracle/convert-sql-server-to-oracle.html

 

2-convert from MySQL to oracle

http://www.sqlie.com/sqlie-services/convert-to-oracle/convert-mysql-to-oracle.html

 

 

3-convert from postgresql to oracle

http://www.sqlie.com/sqlie-services/convert-to-oracle/convert-postgresql-to-oracle.html

 

4-convert from oracle to sql server

http://www.sqlie.com/sqlie-services/convert-to-sql-server/convert-oracle-to-sql-server.html

 

5-convert from MYSQL to SQL Server

Show More

You can use SQLIE app 

SQLIE is used to covert from oracle to postgresql and vise vers 

You can visit  website and download the trial version 

https://www.sqlie.com/

SQLIE is also used to :

1-convert from sql server to oracle

http://www.sqlie.com/sqlie-services/convert-to-oracle/convert-sql-server-to-oracle.html

 

2-convert from MySQL to oracle

http://www.sqlie.com/sqlie-services/convert-to-oracle/convert-mysql-to-oracle.html

 

 

3-convert from postgresql to oracle

http://www.sqlie.com/sqlie-services/convert-to-oracle/convert-postgresql-to-oracle.html

 

4-convert from oracle to sql server

http://www.sqlie.com/sqlie-services/convert-to-sql-server/convert-oracle-to-sql-server.html

 

5-convert from MYSQL to SQL Server

http://www.sqlie.com/sqlie-services/convert-to-sql-server/convert-mysql-to-sql-server.html

 

6-convert from postgresql to sql server

http://www.sqlie.com/sqlie-services/convert-to-sql-server/convert-postgresql-to-sql-server.html

 

7-convert Oracle to MYSQL

http://www.sqlie.com/sqlie-services/convert-to-mysql/convert-oracle-to-mysql.html

 

8- convert Sql Server to MYSQL

http://www.sqlie.com/sqlie-services/convert-to-mysql/convert-sql-server-to-mysql.html

 

9-convert PostgreSQL to MYSQL

http://www.sqlie.com/sqlie-services/convert-to-sql-server/convert-postgresql-to-sql-server.html

 

10-convert oracle to postgresql

http://www.sqlie.com/sqlie-services/convert-to-postgresql/convert-oracle-to-postgresql.html

 

11-convert sql server to postgresql

http://www.sqlie.com/sqlie-services/convert-to-postgresql/convert-sql-server-to-postgresql.html

 

12-convert mysql to postgresql

http://www.sqlie.com/sqlie-services/convert-to-postgresql/convert-mysql-to-postgresql.html


Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice