BenDippenaar wrote:It would be really nice if the data generator could generate data that matches the referential ‘footprint’ of the data it is generating from.
for example, it doesn't seem like i can preserve existing many-to-one relationships in the anonymized database.
We are trying to do exactly the same thing. We have three tables:
Address, Customer, CustomerAddresses (contains only 2 FKs: AddressId and CustomerId). A Customer can have 0 to many Addresses.
The goal is to generate new address info and customer names but keep the same FKs in the CustomerAddresses table. I am using the "Use existing data source" option and am referencing a copy of the database to generate/import the data from Address and Customer. What I want to do is to import the CustomerAddresses table EXACTLY as it is. Same Id values in each row.
In the "real" database, the data looks like this:
1 (and then street1, city, state, zip, etc.)
1 (and then name, credit limit, etc.)
CustomerId / AddressId
But when we generate the CustomerAddresses table with "Use existing data source" it forces us to use the Foreign Key Generator for these two columns. We can't change it. How can we just use the existing data and not generate anything?
We cannot de-select the CustomerAddresses table for generation because it chokes when trying to delete all the rows from Customer.