database 测试用户数据（假数据）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/410653/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Test User Data (Fake Data)
提问by jamtoday
Where can I get, or how can I generate a large formatted collection of fake user data (names, email address, locations, etc.) that can be used for testing an application?
我可以从哪里获取，或者如何生成可用于测试应用程序的大量虚假用户数据（姓名、电子邮件地址、位置等）的大格式集合？
It can be clearly fake, this will be limited to the development server. But I'm sure anything would be better than what I could come up with.
它可以明显是假的，这将仅限于开发服务器。但我相信任何事情都会比我能想出的更好。
回答by Lance Fisher
There are some tools built just for this. I've used http://www.generatedata.com/before to generate data for MySql databases. RedGate has a nice tool to fill your SQL Server database with test data called SQL Data Generator. The RedGate tool costs about $300, but there is a free trial.
有一些专门为此构建的工具。我之前使用过http://www.generatedata.com/为 MySql 数据库生成数据。RedGate 有一个很好的工具，可以用称为SQL Data Generator 的测试数据填充 SQL Server 数据库。RedGate 工具的成本约为 300 美元，但可以免费试用。
UPDATE: Faker.jsis now available. It is a project built on node.js, and looks pretty comprehensive.
更新： Faker.js现在可用。它是一个基于 node.js 的项目，看起来非常全面。
ANOTHER UPDATE: Mockaroois great!
If you'd like an HTTP API of fake user data, check out Random User Generator
如果您想要伪造用户数据的 HTTP API，请查看随机用户生成器
回答by thetacom
This is a open source tool for generating various types of test data. http://www.generatedata.com
这是一个用于生成各种类型测试数据的开源工具。http://www.generatedata.com
回答by Ian Mercer
http://www.fakenamegenerator.com/is a good resource for creating test data with realistic looking users complete with SSN, email address, ... They have a bulk download option too.
http://www.fakenamegenerator.com/是一个很好的资源，用于创建具有真实外观的用户的测试数据，包括 SSN、电子邮件地址……他们也有批量下载选项。
回答by Jon Erickson
Check out this list of "Funny Names" some of them are classic
看看这个“有趣的名字”列表，其中一些是经典的
回答by Jon Erickson
Another open source test generator tool is my own http://code.google.com/p/csvtest.
另一个开源测试生成器工具是我自己的http://code.google.com/p/csvtest。
回答by Trem
For anyone looking for an updated solution to this problem... I wrote a test data generator project for Data Synchronisation Studio. It can generate a large dataset ranging from 1 to 100s of millions of rows of realistic testing data (lots of OFs there :D) Anyway, here is a blog post all about it. http://www.simego.com/Blog/2012/02/Test-Data-Generator-Download-for-Data-Sync
对于寻找此问题的更新解决方案的任何人...我为 Data Synchronization Studio 编写了一个测试数据生成器项目。它可以生成从 1 到 100 几百万行真实测试数据的大型数据集（那里有很多 OF :D）无论如何，这里有一篇关于它的博客文章。http://www.simego.com/Blog/2012/02/Test-Data-Generator-Download-for-Data-Sync
