New Data Generation Feature

[dom]

Hi

Firstly it's great to see that DB Forge now has some means to generate data. I'm hoping that this is a feature that you plan to expand, specifically:

Will there be a way to create meaningful data for certain types of fields (I'm thinking here of things like name fields where it would be beneficial to see real names rather than random string collections). The same might be true for things like post/zip codes and countries. One way to achieve this might be through the use of external xml files that contained collections of items (perhaps there might even be a way for Devart users to submit or collaborate on the creation of such files).

I have not had the opportunity to fully test this feature yet, something I hope to do over the next couple of days, but one question does spring to mind immediately, does the data generator deal with linked tables where you would want certain items (typically id values) to be identical across the related tables?

Dom

[alexa]

Will there be a way to create meaningful data for certain types of fields (I'm thinking here of things like name fields where it would be beneficial to see real names rather than random string collections). The same might be true for things like post/zip codes and countries. One way to achieve this might be through the use of external xml files that contained collections of items (perhaps there might even be a way for Devart users to submit or collaborate on the creation of such files).

We are planning to expand this feature in the future versions, so it will be possible to populate objects with meaningful data.

does the data generator deal with linked tables where you would want certain items (typically id values) to be identical across the related tables?

Yes, it does. There are such options as 'Disable primary keys, indexes and unique constraints', 'Disable foreign keys', 'Disable check constraints', 'Disable DML triggers', etc. that you can turn on/off on the 'Options' page of the data population wizard.

[dom]

We are planning to expand this feature in the future versions, so it will be possible to populate objects with meaningful data.

Sounds great looking forward to seeing it in the hopefully not too distant future.


Thanks for the additional info about linked tables. I suspect that your documentation could probably do with a little bit of expansion / explanation in this area.

Dom

[alexa]

Please see the Data Generator and Working with Data Generator sections in the product's Help documentation.