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 <techse...@gmail.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 >