用随机数据填充数据库 [英] Fill database with random data

问题描述

是否有可以为我生成数据库数据的软件？我想对数据库性能进行一些测试，我只想拥有不同类型的数据。我希望有一些表格，我可以输入类型和数量，让软件生成随机值。

解决方案

VS2010提供了这样做的功能 - http://msdn.microsoft.com/en-us/library/dd193262%28v= vs.100％29.aspx [ ^ ]。



似乎还有一些工具可以做到这一点 -

http://www.databasetestdata.com/ [ ^ ]

http：//www.generatedata。 com / [ ^ ]

< blockquote>这里有更多链接可以帮助您入门：

http://www.red-gate.com/products/sql-development/sql-data-generator/ [ ^ ]

http://databene.org/databene-benerator

http://www.webresourcesdepot.com/test-sample-data-generators/

Is there software that can generate database data for me? I want to conduct some test on database performance and I just want to have different types of data. I would like to have some form where I can enter type and quantity and let software generate random values.

解决方案

VS2010 provides a feature to do this - http://msdn.microsoft.com/en-us/library/dd193262%28v=vs.100%29.aspx[^].

There seem to be some tools available to do this as well -
http://www.databasetestdata.com/[^]
http://www.generatedata.com/[^]

Here is a more links to get you started:
http://www.red-gate.com/products/sql-development/sql-data-generator/[^]
http://databene.org/databene-benerator
http://www.webresourcesdepot.com/test-sample-data-generators/

这篇关于用随机数据填充数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！