pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle to PostgreSQL migration
29+ messages / 18 participants
[nested] [flat]
* Oracle to PostgreSQL migration
@ 2003-12-09 06:49 Randy Harris <randy@SpamFree.com>
0 siblings, 1 reply; 29+ messages in thread
From: Randy Harris @ 2003-12-09 06:49 UTC (permalink / raw)
To: pgsql-general
I've been scouring the PostgreSQL web site and have found several references
to a Database Migration Wizard. I was unable, however, to find any details.
Would someone be kind enough to explain what and where it is? I need to
migrate an Oracle db to PostgreSQL.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL migration
@ 2003-12-10 01:16 Uwe C. Schroeder <uwe@oss4u.com>
parent: Randy Harris <randy@SpamFree.com>
0 siblings, 0 replies; 29+ messages in thread
From: Uwe C. Schroeder @ 2003-12-10 01:16 UTC (permalink / raw)
To: Randy Harris <randy@SpamFree.com>; pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I think that's been part of pgadmin 2
On Monday 08 December 2003 10:49 pm, Randy Harris wrote:
> I've been scouring the PostgreSQL web site and have found several
> references to a Database Migration Wizard. I was unable, however, to find
> any details. Would someone be kind enough to explain what and where it is?
> I need to migrate an Oracle db to PostgreSQL.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
- --
UC
- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/1nP4jqGXBvRToM4RAtNDAJwOOpIgk1da1DMmC2DvcNONZHk77ACgu2b0
QBvZnGi+n3yvBFPDnu542Zk=
=2xqU
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 29+ messages in thread
* Oracle to PostgreSQL migration
@ 2015-02-20 15:26 sridhar bamandlapally <sridhar.bn1@gmail.com>
0 siblings, 0 replies; 29+ messages in thread
From: sridhar bamandlapally @ 2015-02-20 15:26 UTC (permalink / raw)
To: pgsql-general
Hi
With minimal application code changes we are able to migrate database from
Oracle to PostgreSQL successfully (including performance issues) on
production
This we did on high read intensive database sized 900+GB
Thanks to PostgreSQL
Thanks
Sridhar BN
^ permalink raw reply [nested|flat] 29+ messages in thread
* Oracle to PostgreSQL Migration.
@ 2017-05-29 09:08 PAWAN SHARMA <er.pawanshr0963@gmail.com>
0 siblings, 1 reply; 29+ messages in thread
From: PAWAN SHARMA @ 2017-05-29 09:08 UTC (permalink / raw)
To: pgsql-general
Hi All,
I am going to migrate Oracle database into PostgreSQL using ora2pg tools.
I have installed Strawberry Perl.
C:\ora2pg>perl -v
This is perl 5, version 24, subversion 1 (v5.24.1) built for
MSWin32-x64-multi-thread
Copyright 1987-2017, Larry Wall
I am facing below issue while running below command.
*C:\ora2pg>ora2pg -c ora2pg.conf*
DBI connect('host=<servername>;sid=<SID>;port=<port>',<username>',...)
failed: ORA-01017: invalid username/p
assword; logon denied (DBD ERROR: OCISessionBegin) at
C:/Strawberry/perl/site/lib/Ora2Pg.pm line 1376.
FATAL: 1017 ... ORA-01017: invalid username/password; logon denied (DBD
ERROR: OCISessionBegin)
Aborting export...
even I am able to login in Oracle with same <username> and <password>
*entry in sqlnet.ora*
SQLNET.AUTHENTICATION_SERVICES = (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
Please suggest.!!!!!!!!!!!!!!
-Pawan
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 09:19 Chris Mair <chris@1006.org>
parent: PAWAN SHARMA <er.pawanshr0963@gmail.com>
0 siblings, 1 reply; 29+ messages in thread
From: Chris Mair @ 2017-05-29 09:19 UTC (permalink / raw)
To: PAWAN SHARMA <er.pawanshr0963@gmail.com>; pgsql-general
> I am facing below issue while running below command.
>
> *C:\ora2pg>ora2pg -c ora2pg.conf*
> DBI connect('host=<servername>;sid=<SID>;port=<port>',<username>',...) failed: ORA-01017: invalid username/p
> assword; logon denied (DBD ERROR: OCISessionBegin) at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 1376.
> FATAL: 1017 ... ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
> Aborting export...
>
> even I am able to login in Oracle with same <username> and <password>
If you can login from the same host using sqlplus like this:
sqlplus myuser/mypass@myhost:1521/mysid
then you likely can have ora2pg connect too. Just make sure that in ora2pg.conf you put the lines:
ORACLE_DSN dbi:Oracle:host=myhost;sid=mysid
ORACLE_USER myuser
ORACLE_PWD mypass
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 11:00 PAWAN SHARMA <er.pawanshr0963@gmail.com>
parent: Chris Mair <chris@1006.org>
0 siblings, 1 reply; 29+ messages in thread
From: PAWAN SHARMA @ 2017-05-29 11:00 UTC (permalink / raw)
To: Chris Mair <chris@1006.org>; +Cc: pgsql-general
On Mon, May 29, 2017 at 2:49 PM, Chris Mair <chris@1006.org> wrote:
> I am facing below issue while running below command.
>>
>> *C:\ora2pg>ora2pg -c ora2pg.conf*
>> DBI connect('host=<servername>;sid=<SID>;port=<port>',<username>',...)
>> failed: ORA-01017: invalid username/p
>> assword; logon denied (DBD ERROR: OCISessionBegin) at
>> C:/Strawberry/perl/site/lib/Ora2Pg.pm line 1376.
>> FATAL: 1017 ... ORA-01017: invalid username/password; logon denied (DBD
>> ERROR: OCISessionBegin)
>> Aborting export...
>>
>> even I am able to login in Oracle with same <username> and <password>
>>
>
> If you can login from the same host using sqlplus like this:
>
> sqlplus myuser/mypass@myhost:1521/mysid
>
> then you likely can have ora2pg connect too. Just make sure that in
> ora2pg.conf you put the lines:
>
> ORACLE_DSN dbi:Oracle:host=myhost;sid=mysid
> ORACLE_USER myuser
> ORACLE_PWD mypass
>
> Bye,
> Chris.
>
>
>
Hi Chris,
C:\ora2pg>ora2pg -c ora2pg.conf
[========================>] 2/2 tables (100.0%) end of scanning.
[> ] 0/2 tables (0.0%) end of scanning.
[========================>] 2/2 tables (100.0%) end of table export.
-- Generated by Ora2Pg, the Oracle database Schema converter, version 18.1
-- Copyright 2000-2017 Gilles DAROLD. All rights reserved.
-- DATASOURCE: dbi:Oracle:host=<server_name>;sid=<mysid>;port=1521
SET client_encoding TO 'UTF8';
\set ON_ERROR_STOP ON
CREATE TABLE test (
id bigint,
name varchar(30)
) ;
CREATE TABLE mytab (
id bigint,
name varchar(30),
dt timestamp
) ;
DBD::Pg::st execute failed: ERROR: relation "mytab" does not exist
LINE 1: INSERT INTO mytab (id,name,dt) VALUES ($1,$2,$3)
^ at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 11574.
FATAL: ERROR: relation "mytab" does not exist
LINE 1: INSERT INTO mytab (id,name,dt) VALUES ($1,$2,$3)
^
Aborting export...
C:\ora2pg>
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 12:58 Chris Mair <chris@1006.org>
parent: PAWAN SHARMA <er.pawanshr0963@gmail.com>
0 siblings, 1 reply; 29+ messages in thread
From: Chris Mair @ 2017-05-29 12:58 UTC (permalink / raw)
To: PAWAN SHARMA <er.pawanshr0963@gmail.com>; +Cc: pgsql-general
> C:\ora2pg>ora2pg -c ora2pg.conf
> [========================>] 2/2 tables (100.0%) end of scanning.
> [> ] 0/2 tables (0.0%) end of scanning.
> [========================>] 2/2 tables (100.0%) end of table export.
Looks good so far.
This means you could connect to Oracle DB now.
> DBD::Pg::st execute failed: ERROR: relation "mytab" does not exist
This is coming from the Postgres side.
In ora2pg.conf go to the section
OUTPUT SECTION (Control output to file or PostgreSQL database)
I suggest you comment out (prefix with #) the part
#PG_DSN dbi:Pg:dbname=test_db;host=localhost;port=5432
#PG_USER test
#PG_PWD test
and just have ora2pg write its ouput to a file by setting OUTPUT like this:
OUTPUT output.sql
This way you have your oputput for Postgres in a file that you can check out
and try importing step by step. I guess you are running this on some test
data, so the file will be small enough to open it with an editor.
You cap paste piece by piece into a Postgres prompt (psql or pgadmin or whatever
you're using).
You can then see at what point you get an error (and hopefully understand
what's happening).
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 13:16 PAWAN SHARMA <er.pawanshr0963@gmail.com>
parent: Chris Mair <chris@1006.org>
0 siblings, 1 reply; 29+ messages in thread
From: PAWAN SHARMA @ 2017-05-29 13:16 UTC (permalink / raw)
To: Chris Mair <chris@1006.org>; +Cc: pgsql-general
On Mon, May 29, 2017 at 6:28 PM, Chris Mair <chris@1006.org> wrote:
> C:\ora2pg>ora2pg -c ora2pg.conf
>> [========================>] 2/2 tables (100.0%) end of scanning.
>> [> ] 0/2 tables (0.0%) end of scanning.
>> [========================>] 2/2 tables (100.0%) end of table export.
>>
>
> Looks good so far.
> This means you could connect to Oracle DB now.
>
>
> DBD::Pg::st execute failed: ERROR: relation "mytab" does not exist
>>
>
> This is coming from the Postgres side.
>
> In ora2pg.conf go to the section
>
> OUTPUT SECTION (Control output to file or PostgreSQL database)
>
> I suggest you comment out (prefix with #) the part
>
> #PG_DSN dbi:Pg:dbname=test_db;host=localhost;port=5432
> #PG_USER test
> #PG_PWD test
>
> and just have ora2pg write its ouput to a file by setting OUTPUT like this:
>
> OUTPUT output.sql
>
> This way you have your oputput for Postgres in a file that you can check
> out
> and try importing step by step. I guess you are running this on some test
> data, so the file will be small enough to open it with an editor.
> You cap paste piece by piece into a Postgres prompt (psql or pgadmin or
> whatever
> you're using).
>
> You can then see at what point you get an error (and hopefully understand
> what's happening).
>
> Bye,
> Chris.
>
>
>
Hi Chris,
Thanks for suggestion.!!!
here in ora2pg.conf, I have used below type in ora2pg.conf and create the
table manually on PostgreSQL server.
*TYPE TABLE*
*output after this*
-------------------------------------
C:\ora2pg>ora2pg -c ora2pg.conf
Ora2Pg version: 18.1
Trying to connect to database:
dbi:Oracle:host=<servername>;sid=<mysid>;port=1521
Isolation level: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
Retrieving table information...
[1] Scanning table MYTAB (1 rows)...
[2] Scanning table TEST (1 rows)...
Dumping table TEST...
Dumping table MYTAB...
-- Generated by Ora2Pg, the Oracle database Schema converter, version 18.1
-- Copyright 2000-2017 Gilles DAROLD. All rights reserved.
-- DATASOURCE: dbi:Oracle:host=<servername>;sid=<mysid>;port=1521
SET client_encoding TO 'UTF8';
\set ON_ERROR_STOP ON
CREATE TABLE test (
id bigint,
name varchar(30)
) ;
CREATE TABLE mytab (
id bigint,
name varchar(30),
dt timestamp
) ;
but, when i am trying to insert data using
TYPE TABLE, INSERT
C:\ora2pg>ora2pg -c ora2pg.conf
[========================>] 2/2 tables (100.0%) end of scanning.
[> ] 0/2 tables (0.0%) end of scanning.
[========================>] 2/2 tables (100.0%) end of table export.
-- Generated by Ora2Pg, the Oracle database Schema converter, version 18.1
-- Copyright 2000-2017 Gilles DAROLD. All rights reserved.
-- DATASOURCE: dbi:Oracle:host=<servername>;sid=<mysid>;port=1521
SET client_encoding TO 'UTF8';
\set ON_ERROR_STOP ON
CREATE TABLE mytab (
id bigint,
name varchar(30),
dt timestamp
) ;
CREATE TABLE test (
id bigint,
name varchar(30)
) ;
[========================>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
[============> ] 1/2 total rows (50.0%) - (4 sec., avg: 0
recs/sec).
Out of memory! ] 1/2 rows (50.0%) on total estimated data (4
sec., avg: 0 recs/sec)
Issuing rollback() due to DESTROY without explicit disconnect() of
DBD::Oracle::db handle (DESCRIPTION=(ADDRESS=(PO
RT=1521)(PROTOCOL=tcp)(HOST=<servername>))(CONNECT_DATA=(SID=<mysid>))) at
C:/Strawberry/perl/vendor/
lib/DBD/Oracle.pm line 348.
So, It will show data enter in mytab 100% but in test it is 50%. but when I
checked on PostgreSQL server their data only in one table.
test=# select * from mytab ;
id | name | dt
----+------+---------------------
1 | aa | 2017-05-29 06:05:46
(1 row)
test=# select * from test;
id | name
----+------
(0 rows)
So, I am stuck here..!!! Please suggest.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 13:21 Chris Mair <chris@1006.org>
parent: PAWAN SHARMA <er.pawanshr0963@gmail.com>
0 siblings, 1 reply; 29+ messages in thread
From: Chris Mair @ 2017-05-29 13:21 UTC (permalink / raw)
To: PAWAN SHARMA <er.pawanshr0963@gmail.com>; +Cc: pgsql-general
> [========================>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
> [============> ] 1/2 total rows (50.0%) - (4 sec., avg: 0 recs/sec).
> Out of memory! ] 1/2 rows (50.0%) on total estimated data (4 sec., avg: 0 recs/sec)
> Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Oracle::db handle (DESCRIPTION=(ADDRESS=(PO
> RT=1521)(PROTOCOL=tcp)(HOST=<servername>))(CONNECT_DATA=(SID=<mysid>))) at C:/Strawberry/perl/vendor/
> lib/DBD/Oracle.pm line 348.
>
>
> So, It will show data enter in mytab 100% but in test it is 50%. but when I checked on PostgreSQL server their data only in one table.
Did you notice the "Out of memory!" you got there?
I guess that's the problem now...
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 13:24 PAWAN SHARMA <er.pawanshr0963@gmail.com>
parent: Chris Mair <chris@1006.org>
0 siblings, 1 reply; 29+ messages in thread
From: PAWAN SHARMA @ 2017-05-29 13:24 UTC (permalink / raw)
To: Chris Mair <chris@1006.org>; +Cc: pgsql-general
On Mon, May 29, 2017 at 6:51 PM, Chris Mair <chris@1006.org> wrote:
> [========================>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
>> [============> ] 1/2 total rows (50.0%) - (4 sec., avg: 0
>> recs/sec).
>> Out of memory! ] 1/2 rows (50.0%) on total estimated data (4
>> sec., avg: 0 recs/sec)
>> Issuing rollback() due to DESTROY without explicit disconnect() of
>> DBD::Oracle::db handle (DESCRIPTION=(ADDRESS=(PO
>> RT=1521)(PROTOCOL=tcp)(HOST=<servername>))(CONNECT_DATA=(SID=<mysid>)))
>> at C:/Strawberry/perl/vendor/
>> lib/DBD/Oracle.pm line 348.
>>
>>
>> So, It will show data enter in mytab 100% but in test it is 50%. but when
>> I checked on PostgreSQL server their data only in one table.
>>
>
> Did you notice the "Out of memory!" you got there?
>
> I guess that's the problem now...
>
> Bye,
> Chris.
>
>
>
>
>
> ya, but how can fix it.??
because memory is not an issue on both the server.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 13:40 PAWAN SHARMA <er.pawanshr0963@gmail.com>
parent: PAWAN SHARMA <er.pawanshr0963@gmail.com>
0 siblings, 2 replies; 29+ messages in thread
From: PAWAN SHARMA @ 2017-05-29 13:40 UTC (permalink / raw)
To: Chris Mair <chris@1006.org>; +Cc: pgsql-general
On Mon, May 29, 2017 at 6:54 PM, PAWAN SHARMA <er.pawanshr0963@gmail.com>
wrote:
>
>
> On Mon, May 29, 2017 at 6:51 PM, Chris Mair <chris@1006.org> wrote:
>
>> [========================>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
>>> [============> ] 1/2 total rows (50.0%) - (4 sec., avg: 0
>>> recs/sec).
>>> Out of memory! ] 1/2 rows (50.0%) on total estimated data (4
>>> sec., avg: 0 recs/sec)
>>> Issuing rollback() due to DESTROY without explicit disconnect() of
>>> DBD::Oracle::db handle (DESCRIPTION=(ADDRESS=(PO
>>> RT=1521)(PROTOCOL=tcp)(HOST=<servername>))(CONNECT_DATA=(SID=<mysid>)))
>>> at C:/Strawberry/perl/vendor/
>>> lib/DBD/Oracle.pm line 348.
>>>
>>>
>>> So, It will show data enter in mytab 100% but in test it is 50%. but
>>> when I checked on PostgreSQL server their data only in one table.
>>>
>>
>> Did you notice the "Out of memory!" you got there?
>>
>> I guess that's the problem now...
>>
>> Bye,
>> Chris.
>>
>>
>>
>>
>>
>> ya, but how can fix it.??
>
> because memory is not an issue on both the server.
>
>
Hi Chris,
I am able to get the output script in output.sql but now data migration is
the big problem.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 13:45 Neil Anderson <neil@postgrescompare.com>
parent: PAWAN SHARMA <er.pawanshr0963@gmail.com>
1 sibling, 0 replies; 29+ messages in thread
From: Neil Anderson @ 2017-05-29 13:45 UTC (permalink / raw)
To: PAWAN SHARMA <er.pawanshr0963@gmail.com>; +Cc: Chris Mair <chris@1006.org>; pgsql-general
>>>
>>>
>> ya, but how can fix it.??
>>
>> because memory is not an issue on both the server.
>>
>
I've never used ora2pg but there is some documentation saying that
often an out of memory issue can be fixed by adjusting your DATA_LIMIT
setting. https://github.com/darold/ora2pg/blob/master/README#L307
> Hi Chris,
>
> I am able to get the output script in output.sql but now data migration is
> the big problem.
--
Neil Anderson
neil@postgrescompare.com
https://www.postgrescompare.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 13:47 Adrian Klaver <adrian.klaver@aklaver.com>
parent: PAWAN SHARMA <er.pawanshr0963@gmail.com>
1 sibling, 1 reply; 29+ messages in thread
From: Adrian Klaver @ 2017-05-29 13:47 UTC (permalink / raw)
To: PAWAN SHARMA <er.pawanshr0963@gmail.com>; Chris Mair <chris@1006.org>; +Cc: pgsql-general
On 05/29/2017 06:40 AM, PAWAN SHARMA wrote:
>
> ya, but how can fix it.??
>
> because memory is not an issue on both the server.
>
>
> Hi Chris,
>
> I am able to get the output script in output.sql but now data migration
> is the big problem.
http://ora2pg.darold.net/documentation.html#postgresql_import
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration.
@ 2017-05-29 14:21 PAWAN SHARMA <er.pawanshr0963@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 0 replies; 29+ messages in thread
From: PAWAN SHARMA @ 2017-05-29 14:21 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: Chris Mair <chris@1006.org>; pgsql-general
On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
> On 05/29/2017 06:40 AM, PAWAN SHARMA wrote:
>
>>
>>
> ya, but how can fix it.??
>>
>> because memory is not an issue on both the server.
>>
>>
>> Hi Chris,
>>
>> I am able to get the output script in output.sql but now data migration
>> is the big problem.
>>
>
> http://ora2pg.darold.net/documentation.html#postgresql_import
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
Thanks all,
now it's working After DATA_LIMIT 15000 in ora2pg.conf.
test migration is successful.
C:\ora2pg>ora2pg -c ora2pg.conf
[========================>] 2/2 tables (100.0%) end of scanning.
[> ] 0/2 tables (0.0%) end of scanning.
[========================>] 2/2 tables (100.0%) end of table export.
-- Generated by Ora2Pg, the Oracle database Schema converter, version 18.1
-- Copyright 2000-2017 Gilles DAROLD. All rights reserved.
-- DATASOURCE: dbi:Oracle:host=<servername>;sid=<mysid>;port=1521
SET client_encoding TO 'UTF8';
\set ON_ERROR_STOP ON
CREATE TABLE mytab (
id bigint,
name varchar(30),
dt timestamp
) ;
CREATE TABLE test (
id bigint,
name varchar(30)
) ;
[========================>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
[============> ] 1/2 total rows (50.0%) - (4 sec., avg: 0
recs/sec).
[========================>] 1/1 rows (100.0%) Table TEST (0 recs/sec)
[========================>] 2/2 total rows (100.0%) - (261 sec., avg: 0
recs/sec).
[========================>] 2/2 rows (100.0%) on total estimated data (262
sec., avg: 0 recs/sec)
C:\ora2pg>
^ permalink raw reply [nested|flat] 29+ messages in thread
* Oracle to postgresql migration
@ 2022-02-03 14:54 Rama Krishnan <raghuldrag@gmail.com>
0 siblings, 1 reply; 29+ messages in thread
From: Rama Krishnan @ 2022-02-03 14:54 UTC (permalink / raw)
To: pgsql-general
Hi team,
How do we take care of database character set when trying to migrate from
oracle to postgres
In this example I am having in German
Attachments:
IMG_20220203_202338_337.jpg (image/jpeg, 137.4K) download
view image
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to postgresql migration
@ 2022-02-03 15:10 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Rama Krishnan <raghuldrag@gmail.com>
0 siblings, 0 replies; 29+ messages in thread
From: Laurenz Albe @ 2022-02-03 15:10 UTC (permalink / raw)
To: Rama Krishnan <raghuldrag@gmail.com>; pgsql-general
On Thu, 2022-02-03 at 20:24 +0530, Rama Krishnan wrote:
> How do we take care of database character set when trying
> to migrate from oracle to postgres
If NLS_SORT and NLS_COMP are set to German in Oracle,
just create the PostgreSQL to a German collation to get
a similar behavior.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 29+ messages in thread
* Oracle to PostgreSQL Migration
@ 2023-03-20 12:57 Inzamam Shafiq <inzamam.shafiq@hotmail.com>
0 siblings, 3 replies; 29+ messages in thread
From: Inzamam Shafiq @ 2023-03-20 12:57 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi,
Hope everyone is fine.
Can someone help or guide regarding Open Source tools for Oracle to PostgreSQL migration with real time CDC. along with this is there any possibility to change the structure of the database? Let me explain a little more,
We have an Oracle DB which is around 1TB and we want to migrate to PostgreSQL that have a new table structure, so we want to perform data transformation and real time CDC from Oracle to PostgreSQL. Do we have any good open source tool to achieve this with No Coding involved.??
Thanks.
Regards,
Inzamam Shafiq
Sr. DBA
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-20 14:15 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
2 siblings, 1 reply; 29+ messages in thread
From: Ron Johnson @ 2023-03-20 14:15 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Real-time CDC is the difficult part. ora2pg (using views) can do a static
migration. No coding (unless you consider clever use of bash to modify
config files to be coding). I used it to migrate a 7TB db to Postgresql.
https://ora2pg.darold.net/
On Mon, Mar 20, 2023 at 8:58 AM Inzamam Shafiq <inzamam.shafiq@hotmail.com>
wrote:
> Hi,
>
> Hope everyone is fine.
>
> Can someone help or guide regarding Open Source tools for Oracle to
> PostgreSQL migration with real time CDC. along with this is there any
> possibility to change the structure of the database? Let me explain a
> little more,
>
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform data
> transformation and real time CDC from Oracle to PostgreSQL. Do we have any
> good open source tool to achieve this with No Coding involved.??
>
> Thanks.
>
> Regards,
>
> *Inzamam Shafiq*
> *Sr. DBA*
>
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-20 14:21 Thomas Kellerer <shammat@gmx.net>
parent: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
2 siblings, 2 replies; 29+ messages in thread
From: Thomas Kellerer @ 2023-03-20 14:21 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform
> data transformation and real time CDC from Oracle to PostgreSQL. Do
> we have any good open source tool to achieve this with No Coding
> involved.??
You could try debezium, but I don't know how good it works and if it qualifies as "no coding involved"
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-20 14:24 Jim Mlodgenski <jimmy76@gmail.com>
parent: Thomas Kellerer <shammat@gmx.net>
1 sibling, 0 replies; 29+ messages in thread
From: Jim Mlodgenski @ 2023-03-20 14:24 UTC (permalink / raw)
To: Thomas Kellerer <shammat@gmx.net>; +Cc: pgsql-general@lists.postgresql.org
On Mon, Mar 20, 2023 at 10:21 AM Thomas Kellerer <shammat@gmx.net> wrote:
> Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> > We have an Oracle DB which is around 1TB and we want to migrate to
> > PostgreSQL that have a new table structure, so we want to perform
> > data transformation and real time CDC from Oracle to PostgreSQL. Do
> > we have any good open source tool to achieve this with No Coding
> > involved.??
>
>
> You could try debezium, but I don't know how good it works and if it
> qualifies as "no coding involved"
>
>
I've seen some good results using SymmetricDS
https://www.symmetricds.org/
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-21 05:34 Inzamam Shafiq <inzamam.shafiq@hotmail.com>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 29+ messages in thread
From: Inzamam Shafiq @ 2023-03-21 05:34 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi Ron,
I have used ora2pg for a small database, but we have limitation of zero downtime, how do we replicate real time data from Oracle to PostgreSQL. We can migrate schema from Oracle to PostgreSQL using ora2pg and single time bulk data but what about the changed data after bulk load?
Regards,
Inzamam Shafiq
Sr. DBA
________________________________
From: Ron Johnson <ronljohnsonjr@gmail.com>
Sent: Monday, March 20, 2023 7:15 PM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Oracle to PostgreSQL Migration
Real-time CDC is the difficult part. ora2pg (using views) can do a static migration. No coding (unless you consider clever use of bash to modify config files to be coding). I used it to migrate a 7TB db to Postgresql.
https://ora2pg.darold.net/
On Mon, Mar 20, 2023 at 8:58 AM Inzamam Shafiq <inzamam.shafiq@hotmail.com<mailto:inzamam.shafiq@hotmail.com>> wrote:
Hi,
Hope everyone is fine.
Can someone help or guide regarding Open Source tools for Oracle to PostgreSQL migration with real time CDC. along with this is there any possibility to change the structure of the database? Let me explain a little more,
We have an Oracle DB which is around 1TB and we want to migrate to PostgreSQL that have a new table structure, so we want to perform data transformation and real time CDC from Oracle to PostgreSQL. Do we have any good open source tool to achieve this with No Coding involved.??
Thanks.
Regards,
Inzamam Shafiq
Sr. DBA
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-21 05:36 Inzamam Shafiq <inzamam.shafiq@hotmail.com>
parent: Thomas Kellerer <shammat@gmx.net>
1 sibling, 1 reply; 29+ messages in thread
From: Inzamam Shafiq @ 2023-03-21 05:36 UTC (permalink / raw)
To: Thomas Kellerer <shammat@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi Thomas,
We have tried kafka, but in that we stuck in CDC part, update/delete was not working due to some NULL value issue. Do you have any helping material for Oracle to PostgreSQL data migration using debezium?
Regards,
Inzamam Shafiq
Sr. DBA
________________________________
From: Thomas Kellerer <shammat@gmx.net>
Sent: Monday, March 20, 2023 7:21 PM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Oracle to PostgreSQL Migration
Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform
> data transformation and real time CDC from Oracle to PostgreSQL. Do
> we have any good open source tool to achieve this with No Coding
> involved.??
You could try debezium, but I don't know how good it works and if it qualifies as "no coding involved"
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-21 10:48 Umair Shahid <umair.shahid@gmail.com>
parent: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
0 siblings, 1 reply; 29+ messages in thread
From: Umair Shahid @ 2023-03-21 10:48 UTC (permalink / raw)
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>; +Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Could oracle_fdw <https://github.com/laurenz/oracle_fdw; help in your use
case? You could consider setting up a job to pull data into PostgreSQL live
and then cut over when you are ready.
- Umair
On Tue, Mar 21, 2023 at 10:36 AM Inzamam Shafiq <inzamam.shafiq@hotmail.com>
wrote:
> Hi Thomas,
>
> We have tried kafka, but in that we stuck in CDC part, update/delete was
> not working due to some NULL value issue. Do you have any helping material
> for Oracle to PostgreSQL data migration using debezium?
>
> Regards,
>
> *Inzamam Shafiq*
> *Sr. DBA*
> ------------------------------
> *From:* Thomas Kellerer <shammat@gmx.net>
> *Sent:* Monday, March 20, 2023 7:21 PM
> *To:* pgsql-general@lists.postgresql.org <
> pgsql-general@lists.postgresql.org>
> *Subject:* Re: Oracle to PostgreSQL Migration
>
> Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> > We have an Oracle DB which is around 1TB and we want to migrate to
> > PostgreSQL that have a new table structure, so we want to perform
> > data transformation and real time CDC from Oracle to PostgreSQL. Do
> > we have any good open source tool to achieve this with No Coding
> > involved.??
>
>
> You could try debezium, but I don't know how good it works and if it
> qualifies as "no coding involved"
>
>
>
>
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-21 15:42 Marc Millas <marc.millas@mokadb.com>
parent: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
2 siblings, 1 reply; 29+ messages in thread
From: Marc Millas @ 2023-03-21 15:42 UTC (permalink / raw)
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
EDB do have a replication server which can be used to transfer real time
data from oracle to postgres.
don't know if it can be used to get to "no downtime"
BTW what do you call "no downtime" as anyway a switch, as fast as it can be
do take ""some"" time ?
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Mon, Mar 20, 2023 at 1:58 PM Inzamam Shafiq <inzamam.shafiq@hotmail.com>
wrote:
> Hi,
>
> Hope everyone is fine.
>
> Can someone help or guide regarding Open Source tools for Oracle to
> PostgreSQL migration with real time CDC. along with this is there any
> possibility to change the structure of the database? Let me explain a
> little more,
>
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform data
> transformation and real time CDC from Oracle to PostgreSQL. Do we have any
> good open source tool to achieve this with No Coding involved.??
>
> Thanks.
>
> Regards,
>
> *Inzamam Shafiq*
> *Sr. DBA*
>
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-22 05:27 paramjib baruah <paramjibbaruah@gmail.com>
parent: Marc Millas <marc.millas@mokadb.com>
0 siblings, 0 replies; 29+ messages in thread
From: paramjib baruah @ 2023-03-22 05:27 UTC (permalink / raw)
To: Marc Millas <marc.millas@mokadb.com>; +Cc: Inzamam Shafiq <inzamam.shafiq@hotmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
EDB has migration toolkit , which is very helpful in migration from Oracle
to EDB.
Thanks and Regards
Paramjib Baruah
On Tue, Mar 21, 2023 at 9:12 PM Marc Millas <marc.millas@mokadb.com> wrote:
> EDB do have a replication server which can be used to transfer real time
> data from oracle to postgres.
> don't know if it can be used to get to "no downtime"
> BTW what do you call "no downtime" as anyway a switch, as fast as it can
> be do take ""some"" time ?
>
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com
>
>
>
> On Mon, Mar 20, 2023 at 1:58 PM Inzamam Shafiq <inzamam.shafiq@hotmail.com>
> wrote:
>
>> Hi,
>>
>> Hope everyone is fine.
>>
>> Can someone help or guide regarding Open Source tools for Oracle to
>> PostgreSQL migration with real time CDC. along with this is there any
>> possibility to change the structure of the database? Let me explain a
>> little more,
>>
>> We have an Oracle DB which is around 1TB and we want to migrate to
>> PostgreSQL that have a new table structure, so we want to perform data
>> transformation and real time CDC from Oracle to PostgreSQL. Do we have any
>> good open source tool to achieve this with No Coding involved.??
>>
>> Thanks.
>>
>> Regards,
>>
>> *Inzamam Shafiq*
>> *Sr. DBA*
>>
>
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-24 08:00 Inzamam Shafiq <inzamam.shafiq@hotmail.com>
parent: Umair Shahid <umair.shahid@gmail.com>
0 siblings, 2 replies; 29+ messages in thread
From: Inzamam Shafiq @ 2023-03-24 08:00 UTC (permalink / raw)
To: Umair Shahid <umair.shahid@gmail.com>; +Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi Umair,
Thanks, oracle_fdw can be used, but it doesn't provide real time sync, we have to schedule jobs to insert data in actual schema from foreign tables, so some delay might be there.
Regards,
Inzamam Shafiq
________________________________
From: Umair Shahid <umair.shahid@gmail.com>
Sent: Tuesday, March 21, 2023 3:48 PM
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Oracle to PostgreSQL Migration
Could oracle_fdw<https://github.com/laurenz/oracle_fdw; help in your use case? You could consider setting up a job to pull data into PostgreSQL live and then cut over when you are ready.
- Umair
On Tue, Mar 21, 2023 at 10:36 AM Inzamam Shafiq <inzamam.shafiq@hotmail.com<mailto:inzamam.shafiq@hotmail.com>> wrote:
Hi Thomas,
We have tried kafka, but in that we stuck in CDC part, update/delete was not working due to some NULL value issue. Do you have any helping material for Oracle to PostgreSQL data migration using debezium?
Regards,
Inzamam Shafiq
Sr. DBA
________________________________
From: Thomas Kellerer <shammat@gmx.net<mailto:shammat@gmx.net>>
Sent: Monday, March 20, 2023 7:21 PM
To: pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org> <pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org>>
Subject: Re: Oracle to PostgreSQL Migration
Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform
> data transformation and real time CDC from Oracle to PostgreSQL. Do
> we have any good open source tool to achieve this with No Coding
> involved.??
You could try debezium, but I don't know how good it works and if it qualifies as "no coding involved"
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-24 14:02 Christophe Pettus <xof@thebuild.com>
parent: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
1 sibling, 0 replies; 29+ messages in thread
From: Christophe Pettus @ 2023-03-24 14:02 UTC (permalink / raw)
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform
> data transformation and real time CDC from Oracle to PostgreSQL. Do
> we have any good open source tool to achieve this with No Coding
> involved.??
To meet all of your requirements, you are almost certainly going to need to look at a commercial solution such as:
* EDB's xDB.
* Oracle's Golden Gate.
* FiveTran's HVR.
We've used xDB successfully in the past for this type of migration.
One open-source change capture tool that you might investigate is:
https://www.symmetricds.org
I personally don't have experience with it, but it might be suitable.
Best,
-- Christophe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-03-28 06:26 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
1 sibling, 1 reply; 29+ messages in thread
From: Laurenz Albe @ 2023-03-28 06:26 UTC (permalink / raw)
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>; Umair Shahid <umair.shahid@gmail.com>; +Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
On Fri, 2023-03-24 at 08:00 +0000, Inzamam Shafiq wrote:
> Thanks, oracle_fdw can be used, but it doesn't provide real time sync, we have to
> schedule jobs to insert data in actual schema from foreign tables, so some delay might be there.
In addition to the commercial tools that Christophe mentioned, and which might be
your best option, let me point out that ora_migrator
(https://github.com/cybertec-postgresql/ora_migrator), which is open source and based
on oracle_fdw, offers some degree of what you are looking for using a cursor-based soution.
Certainly net refined and certainly not feasible in cases with high transactional
workload, but perhaps it can be useful for you.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: Oracle to PostgreSQL Migration
@ 2023-04-03 20:17 Jonny Saxon <jonnysaxon@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 29+ messages in thread
From: Jonny Saxon @ 2023-04-03 20:17 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Inzamam Shafiq <inzamam.shafiq@hotmail.com>; Thomas Kellerer <shammat@gmx.net>; Umair Shahid <umair.shahid@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
This is a little left field… but we’ve migrated a lot of onprem oracle
databases to Postgres (on aws rds) using aws database migration service -
which has worked very well and supports cdc.
I do wonder if you did the above and then add a 2nd cdc out from Postgres
rds to your onprem Postgres.
So onprem oracle -> rds Postgres -> onprem Postgres (all working
simultaneously)
(It wouldn’t work onprem oracle to onprem Postgres without a aws cloud
setup)
Just a random thought and fairly straightforward to setup.
On Tue, 28 Mar 2023 at 19:27, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> On Fri, 2023-03-24 at 08:00 +0000, Inzamam Shafiq wrote:
> > Thanks, oracle_fdw can be used, but it doesn't provide real time sync,
> we have to
> > schedule jobs to insert data in actual schema from foreign tables, so
> some delay might be there.
>
> In addition to the commercial tools that Christophe mentioned, and which
> might be
> your best option, let me point out that ora_migrator
> (https://github.com/cybertec-postgresql/ora_migrator), which is open
> source and based
> on oracle_fdw, offers some degree of what you are looking for using a
> cursor-based soution.
> Certainly net refined and certainly not feasible in cases with high
> transactional
> workload, but perhaps it can be useful for you.
>
> Yours,
> Laurenz Albe
>
>
> --
Sent from iPhone
^ permalink raw reply [nested|flat] 29+ messages in thread
end of thread, other threads:[~2023-04-03 20:17 UTC | newest]
Thread overview: 29+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-09 06:49 Oracle to PostgreSQL migration Randy Harris <randy@SpamFree.com>
2003-12-10 01:16 ` Uwe C. Schroeder <uwe@oss4u.com>
2015-02-20 15:26 Oracle to PostgreSQL migration sridhar bamandlapally <sridhar.bn1@gmail.com>
2017-05-29 09:08 Oracle to PostgreSQL Migration. PAWAN SHARMA <er.pawanshr0963@gmail.com>
2017-05-29 09:19 ` Re: Oracle to PostgreSQL Migration. Chris Mair <chris@1006.org>
2017-05-29 11:00 ` Re: Oracle to PostgreSQL Migration. PAWAN SHARMA <er.pawanshr0963@gmail.com>
2017-05-29 12:58 ` Re: Oracle to PostgreSQL Migration. Chris Mair <chris@1006.org>
2017-05-29 13:16 ` Re: Oracle to PostgreSQL Migration. PAWAN SHARMA <er.pawanshr0963@gmail.com>
2017-05-29 13:21 ` Re: Oracle to PostgreSQL Migration. Chris Mair <chris@1006.org>
2017-05-29 13:24 ` Re: Oracle to PostgreSQL Migration. PAWAN SHARMA <er.pawanshr0963@gmail.com>
2017-05-29 13:40 ` Re: Oracle to PostgreSQL Migration. PAWAN SHARMA <er.pawanshr0963@gmail.com>
2017-05-29 13:45 ` Re: Oracle to PostgreSQL Migration. Neil Anderson <neil@postgrescompare.com>
2017-05-29 13:47 ` Re: Oracle to PostgreSQL Migration. Adrian Klaver <adrian.klaver@aklaver.com>
2017-05-29 14:21 ` Re: Oracle to PostgreSQL Migration. PAWAN SHARMA <er.pawanshr0963@gmail.com>
2022-02-03 14:54 Oracle to postgresql migration Rama Krishnan <raghuldrag@gmail.com>
2022-02-03 15:10 ` Re: Oracle to postgresql migration Laurenz Albe <laurenz.albe@cybertec.at>
2023-03-20 12:57 Oracle to PostgreSQL Migration Inzamam Shafiq <inzamam.shafiq@hotmail.com>
2023-03-20 14:15 ` Re: Oracle to PostgreSQL Migration Ron Johnson <ronljohnsonjr@gmail.com>
2023-03-21 05:34 ` Re: Oracle to PostgreSQL Migration Inzamam Shafiq <inzamam.shafiq@hotmail.com>
2023-03-20 14:21 ` Re: Oracle to PostgreSQL Migration Thomas Kellerer <shammat@gmx.net>
2023-03-20 14:24 ` Re: Oracle to PostgreSQL Migration Jim Mlodgenski <jimmy76@gmail.com>
2023-03-21 05:36 ` Re: Oracle to PostgreSQL Migration Inzamam Shafiq <inzamam.shafiq@hotmail.com>
2023-03-21 10:48 ` Re: Oracle to PostgreSQL Migration Umair Shahid <umair.shahid@gmail.com>
2023-03-24 08:00 ` Re: Oracle to PostgreSQL Migration Inzamam Shafiq <inzamam.shafiq@hotmail.com>
2023-03-24 14:02 ` Re: Oracle to PostgreSQL Migration Christophe Pettus <xof@thebuild.com>
2023-03-28 06:26 ` Re: Oracle to PostgreSQL Migration Laurenz Albe <laurenz.albe@cybertec.at>
2023-04-03 20:17 ` Re: Oracle to PostgreSQL Migration Jonny Saxon <jonnysaxon@gmail.com>
2023-03-21 15:42 ` Re: Oracle to PostgreSQL Migration Marc Millas <marc.millas@mokadb.com>
2023-03-22 05:27 ` Re: Oracle to PostgreSQL Migration paramjib baruah <paramjibbaruah@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox