I reflect on some concepts of database design and believe that creating sample data that mimics the real volume of my application will help strengthen some design decisions.
Does anyone know a tool for creating sample data? I was looking for something that is possible for the database and platform neutral (from MySQL to DB / 2 and Windows to UNIX) to test the design on different systems / architectures. Im seeing some kind of tool that you can:
- specify the database table (some DSN configuration, etc.).
- inherit fields and based on the field ... (specify and add or add configuration)
- have the means to express how to create data samples ( MySQL Sample Data Creator - that’s what I think they will have several options, such as a commit frequency, to create very large data sets ... millions or billions of rows ... not think that this tool will scale to the amount of data that I want to create)
- press the button and go (depending on your settings, this may take a long time)
Any thoughts? Of course, I could write an application to do this, but it seems so general that I do not need to reinvent the wheel.
source
share