Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Create Foreign keys automatically when designing the target tables using Target Table creation wizard

Hi Team,

Can i please ask if it is possible to create foreign key constraints automatically for target tables from SDR using the wizard. Currently SDR creates table schema only with primary keys and not any other constraints in the target tables. We have 2000+ tables in current scenario and we cannot individually alter tables in the target or in the target RDBMS.

It will be better if SDR team can add a mechanism or script or something that helps to translate the exact source table DDL into target table DDL.


Thanks!



  • Guest
  • Mar 28 2022
  • Mar 28, 2022

    Admin response

    The challenge with this request is that as the replications will likely be for a subset of tables from the source database environment, the automatic creation of foreign keys is tricky to orchestrate as there would be no guarantee that all tables exist at the point of creation of the replication. It would likely have to be a post replication script option to build out the foreign key constraints on the target model. We'll consider for the future but not something on the roadmap currently.

  • Attach files