Re: DB migration : Sybase to Postgres

2023-05-25 Thread Sengottaiyan T
ons > - Apply FK constraints *after* initial data load. > - Load parent data before child data > > (You can create the FKs ahead of time, but use the NOT VALID clause; then, > after data is loaded do ALTER TABLE ... VALIDATE CONSTRAINT.) > > On 5/25/23 06:30, Sengottaiyan T wrote: >

Re: DB migration : Sybase to Postgres

2023-05-25 Thread Sengottaiyan T
with respective team). After creating proper structure on target, the next step is to load data - I'm sure there will be a lot of errors during initial data load (no parent record found). How to handle it? On Tue, Mar 28, 2023 at 3:22 PM Sengottaiyan T wrote: > Team, > > Need some help regar

DB migration : Sybase to Postgres

2023-03-28 Thread Sengottaiyan T
Team, Need some help regarding Open Source tools for DB migration (from SYBASE to PostgreSQL) with real time CDC. Along with this, is there any possibility to migrate other objects (like Triggers, Stored Procedures and Functions) to PostgreSQL? Thanks, Senko