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