Re: DB migration : Sybase to Postgres

Is there an option to set novalidate constraints in postgres? In my source
Sybase DB, table structures are not defined properly (only primary keys
exist and no foreign key) - I'm making necessary changes on target Postgres
DB (created tables, identifying relationship between table columns 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 <techsenko(at)gmail(dot)com> wrote:

> 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
>