Select tables to populate improvements

The simplest way to populate your database with test data.

Select tables to populate improvements

Postby kampak1111 » Mon Dec 22, 2008 3:43 pm


I usually use the SQL Data Generator to generate data only for specified tables. As I have a lot of tables in database it is very time-consuming to check the checkboxes of tables that I need.

There is a rule in table naming convention that allows me to know which of these I should generate data for.

I would like to be able to choose tables to generate data for in more comfortable way.

Possible Solutions
    Select only selected(?) tables (local menu feature)
    In the local menu of the [Tables to populate] list there are only options: Deselect All, Select All, Select All Other Tables.

    It woul be fine to be able to select (with [CTRL] or [SHIFT]) tables on the list and then click [Select Specified/Selected Items]. I would be able to use [SHIFT] to select a lot of tables with two clicks (not 100 as I need now).
    Select tables - regex
    That local menu, mentioned above, would have a [Select With Regular Expression] command that would allow to specify regular expression to specify tables. It would be very comfortable to remember that also with the project and to reuse it later. This might be used also in the command prompt application (as at the moment command prompt application is not very helpful for me).

Kamil Pakur
Posts: 3
Joined: Sun Aug 10, 2008 5:49 pm

Postby Brian Donahue » Mon Dec 29, 2008 12:15 pm


Thanks for your suggestions. We can certainly look into that. It may be difficult to do, considering that you may also want to assign different generators to each column.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests