我正在思考一些数据库设计概念，并相信创建模拟应用程序实际量的示例数据将有助于巩固一些设计决策。
有人知道创建样本数据的工具吗？ 如果可能的话，我正在寻找与数据库和平台无关的东西（从 MySQL 到 DB/2，从 Windows 到 UNIX），以便跨不同系统/体系结构测试设计。 我正在设想一些工具，您可以：
- 指向数据库表（DSN 的某些配置等）
- 内省字段并基于字段...< /strong> （点击或添加一些配置）
- 有一种表达如何创建示例数据的方法 (MySQL Sample Data Creator 是我的愿景，但我认为他们会提供更多选项，例如提交频率，以便创建非常大的数据集......数百万或数十亿行......不认为这个工具可以扩展到我想要创建的数据量）
- 按下按钮即可（根据您的参数，这可能需要很长时间）
有什么想法吗？ 当然，我可以编写一个应用程序来做到这一点，但它看起来很通用，我不应该重新发明轮子。
I’m thinking through some database design concepts and believe that creating sample data simulating real-world volume of my application will help solidify some design decisions.
Does any anyone know of a tool to create sample data? I’m looking for something that’s database and platform neutral if possible (from MySQL to DB/2 and Windows to UNIX) so to test the design across different systems/architectures. I’m visioning some tool that you can:
- point to a database table(s) (some configuration of the DSN, etc.)
- introspect the fields and based on the field... (point-and-click or add some configuration)
- have a means for expressing how to create sample data (MySQL Sample Data Creator is the kind of thing I vision but I think their'd be some more options like commit frequency so to create very large data sets... millions or billions of rows... don't think this tool would scale to the volume of data I want to create)
- push a button and go (depending on your parameters, this may take a long time)
Any thoughts? Sure, I could write an app to do this but it seems so generic that I shouldn’t have to reinvent the wheel.
发布评论
评论（4）
DBMonster 很好，但我更喜欢 databene benerator 正如我在 中解释的那样这是对类似问题的回答。
DBMonster is fine but I prefer databene benerator as I explained it in this answer to a similar question.
像DBMonster之类的东西？
此页面还列出了许多数据库数据生成器。
Something like DBMonster?
This page also has a listing of many DB data generators.
我无法帮助您使用 MySQL 或 DB/2，但是，如果有人需要 MS SQL Server 来获得此答案，我可以推荐 来自 Red Gate 的数据生成器。
I cannot help you with MySQL or DB/2 but, in case anyone gets to this answer with a need for MS SQL Server, I can recommend the Data Generator from Red Gate.
我们的测试数据生成器 Datanamic DB 数据生成器可以为您做到这一点。 与 MySQL 一起使用。 第一次加载表时，它使用默认的“生成器设置”。 然后，您可以“微调”字段和/或选择其他“生成器”。
Our test data generator, Datanamic DB Data Generator can do this for you. Works with MySQL. It uses default "generator settings" when loading your tables the first time. You can then "fine-tune" the fields and/or choose other "generators".