Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Database conversion

  1. Advice
0
Votes
Undo
  1. Claudio Burns
    Claudio Burns
  2. PowerBuilder
  3. Thursday, 9 December 2021 15:17 PM UTC

Can anybody suggest a tool to reliably convert a Sql anywhere db into a postgreSQL database?

TIA

Claudio Burns

Migration of project to PB 2019 & PowerServer 2020...
How to debug 64-bit app that is "leaking memory" w...
Responses (4)
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Saturday, 11 December 2021 06:09 AM UTC
  2. PowerBuilder
  3. # 1

Hello,

Do you want to transfer only data or all database objects, eg Stored Procedures, Triggers, Functions etc ?

Happiness Always
BKR Sivaprakash

 

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Saturday, 11 December 2021 16:08 PM UTC
  2. PowerBuilder
  3. # 2

We used the company Enterprise DB for our conversion from Oracle to PostgreSQL.
      https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

1. Despite what anyone tells you, there will ALWAYS be SQL that works in Oracle that fails in PG. You will need to recode those blocks.

2. We paid for tech support. It might be a good idea for you to do the same, at least until the database, embedded SQL, database scripts, and all other SQL-based components have been converted and tested successfully.

3. PG databases are NOT case-insensitive. When you define them, they store data EITHER as upper case or as lower case. Use lower case.


Good Luck,

Olan

Comment
There are no comments made yet.
Claudio Burns
Claudio Burns Accepted Answer Pending Moderation
  1. Tuesday, 14 December 2021 16:21 PM UTC
  2. PowerBuilder
  3. # 3

Hi Olan, I thank you for your answer.

Hi BKR Sivaprakash I need to transfer all my db objects and data.

 

Claudio

Comment
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Wednesday, 15 December 2021 06:59 AM UTC
Thanks for the clarification Claudio Burns,

Available possibilities includes ER Diagram tool, which can reverse engineer SQL anywhere database and output PostgreSQL SQL to create one.

Mostly ER tools will be limited to the creation of tables and NOT functions, stored procedures, users, user-rights etc.

Manual work is required at many points with extensive checking cannot be avoided.

For data transfer, I think there are many tools.

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 15 December 2021 17:51 PM UTC
  2. PowerBuilder
  3. # 4

Hi Claudio;

  I would post this question in one of the PostGreSQL Support / Community forums.

FYI: https://www.postgresql.org/community

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.