Re: Post Oracle to Postgres migartion

public inbox for [email protected]  
help / color / mirror / Atom feed

From: DINESH  NAIR <[email protected]>
To: Kamal Lekan AbdulWahab <[email protected]>
To: Raj <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Post Oracle to Postgres migartion
Date: Thu, 31 Jul 2025 19:37:23 +0000
Message-ID: <PN4P287MB4381DBD6FDC7B959956CA9F09C27A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CA+B9d-fWbhRRYaYvQXrT1Jdy9MrDS2qdbSRghdwJR9M9DBkbnQ@mail.gmail.com>
References: <CAJk5Atb+2r430wJqONZLLYvR0ZWcQ8qPc1uuoqZGao_O2wLrrA@mail.gmail.com>
	<CA+B9d-fWbhRRYaYvQXrT1Jdy9MrDS2qdbSRghdwJR9M9DBkbnQ@mail.gmail.com>

Hi ,

          >>  That "etc" is everything except what you didn't explicitly list. 😉

>>Did you create all the same indices and triggers?
>> Did you convert all NUMERIC and NUMERIC(38,0) to BIGINT in Ora2pg?

Best practice followed for migration :

  1.
First perform table data migration. Row count verification between source and target tables. Random data checks between source and target at row level.
  2.  Applying primary key, constraints and indexes
  3.  Applying triggers
  4.  Then sequences migration
  5.  Database configuration: configuration of postgres.config , shared_buffers, max_connections, configuring maintenace jobs
  6.  Setting user roles and permissions

Regards

Dinesh Nair

________________________________
From: Kamal Lekan AbdulWahab <[email protected]>
Sent: Thursday, July 31, 2025 7:47 PM
To: Raj <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Post Oracle to Postgres migartion

You don't often get email from [email protected]. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification;
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.
You can look at SEQUENCES if they are out of sync with values in Oracle. Sometimes, they also affect auto-increment columns. Have you checked and recreated all users accounts? Passwords do not copy over automatically.

On Thu, Jul 31, 2025 at 3:19 AM Raj <[email protected]<mailto:[email protected]>> wrote:
Hi All,

Post Oracle to Postgres Migration using Ora2pg, as a dba what activites we may have to perform apart from checking count of objects, rows, vacuum analyze etc

view thread (7+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Post Oracle to Postgres migartion
  In-Reply-To: <PN4P287MB4381DBD6FDC7B959956CA9F09C27A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox