Skip to content

Feature request: A data generation tool #2009

@robsch

Description

@robsch

Is your feature request related to a problem? Please describe.
I need some dummy data in a table. How can I create, let's say, 100.000 rows? Might be with a stored procedure or creating an appropriate list of Insert statements, with copy and paste, maybe with the help of Excel or so. For me, it is not so obvious, how to do it easily.

But since HeidiSQL already knows the structure of my table/database, I thought it might be adequate to have a generation option in HeidiSQL. I could imagine that it would be helpful to many users, if there is a nice way to create data easily.

Describe the solution you'd like
Not sure. It's up to you. I thought about an separate dialog, where the user can configure how the data should be generated. Of course, there would be a lot of options. But some basic logic could be there, like incrementing a number or date with a certain interval for each row, starting from a certain point. Or alternating between certain values. Or creating random values. Providing constants would be simple.

From a development perspective I'd say, start basic and add more sophisticated things later.

Describe alternatives you've considered
As described above, I do not know how to create data. Possible that other tools exist, but having it within HeidiSQL would be great!

Of course, this is not implemented in a weekend or so. You can think about it and if so, design it as you like. It is just an idea - whatever you'll do with it.

Love HeidiSQL for long time! Great piece of work!

Metadata

Metadata

Assignees

No one assigned

    Labels

    featureA new feature to implement

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions