Re: Oracle 11g to PostgreSQL 10 - Database Migration

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: Oracle 11g to PostgreSQL 10 - Database Migration
Дата
Msg-id CA+t6e1nN=n7V9Qjiz7_1hhtGqhYu+yLQeXDFEfjPde3hRDBx-A@mail.gmail.com
обсуждение исходный текст
Ответ на Oracle 11g to PostgreSQL 10 - Database Migration  (<soumik.bhattacharjee@kpn.com>)
Ответы RE: Oracle 11g to PostgreSQL 10 - Database Migration
Список pgsql-admin
Дерево обсуждения
Hi,
It is very depends on the structure of your database. Before starting try to know everything  about your database - schemas, object types and so on.. Ora2pg is a great tool but sometimes isnt enough for all migrations. Check out oracle_fdw("dblink" to oracle database) and orafce (oracle internal functions for postgresql).

2018-08-14 14:22 GMT+03:00 <soumik.bhattacharjee@kpn.com>:

Hello All,

 

We have a requirement to migrate from Oracle(Multiple versions) – 11gR1,11gR2,12c to PostgreSQL 10 to private cloud of customer  in context to that –

 

1.       Please let me know the best practices for migrations- any documents ,links etc.

2.       Open source tools for migration.

3.       OS and kernel parameters as per PostgreSQL standards for DB instances.

4.       Design and planning for PostgreSQL configurations.

5.       If Ora2pg tool is enough for migration?

 

 

Thanks

Soumik


В списке pgsql-admin по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Oracle 11g to PostgreSQL 10 - Database Migration
Следующее
От:
Дата:
Сообщение: RE: Oracle 11g to PostgreSQL 10 - Database Migration