Activity overview
Latest activity by snyder_rls
We also have a schema for which data cannot be generated without the ability to override or replace the FK Generator.
We have a BusinessEntity table, that has 9 types (e.g. Persons vs Organizations). Address FKs to BusinessEntity, as do Person and Organization. We can't keep BusinessEntity rows from being:
- referenced by the wrong table - with respect to type
- referenced by multiple tables of different types
Our painful workaround is to create specific BusinessEntity tables, temporarily re-linking foreign keys, generate to those tables, and merge back after data generation (manageable because our keys are GUIDs).
A lot of SQL for the pre-scripts (that also has to be executed before editing the .sqlgen package so the generation can be configured), and post-scripts / comments
We also have a schema for which data cannot be generated without the ability to override or replace the FK Generator.
We have a BusinessEntity table, that has 9 types (e.g. Persons vs Organizations...