如何填充我的数据库的所有表随机数据？ [英] How can I populate my database's all tables with random data?

问题描述

有没有这样的软件吗？无论数据本身是否有意义都无关紧要。我只是担心字段填充。基本上，它将读取表定义并相应地生成一些数据。如果它要求每个表插入多少行，默认值是空白还是填充，如何处理varchars（到达完整范围或到给定的指定数量的字符），这将是很好的， 。理想的免费:)，但商业产品的建议也非常受欢迎。
谢谢大家。

Is there such a software out there? It doesn't matter if the data itself make sense. I am just worried about the fields to get populated. Basically, it will read the table definitions and generate some data accordingly. It would also be great if it asks for how many rows to insert per table, whether the default values will be left blank or get populated, how to treat the varchars(to the full extent or up to a given,specified number of characters). Ideally free :) but commercial product suggestions are also highly welcome. Thank you all.

推荐答案

我看到还没有答案被选为最好的。除了此主题中已提及的解决方案外，我还可以使用 ApexSQL Generate - 一个SQL数据生成工具 ，它能够使用各种数据源，使用各种数据生成器快速生成数百万行。

I see there is still no answer that has been chosen as the best. Besides the solutions already mentioned in this thread, I can suggest using ApexSQL Generate – a SQL data generator tool, which has the ability to quickly generate millions of rows, using various data sources, with a variety of data generators.

它具有完全功能的免费试用版，因此您可以下载它并测试看看是否会完成你的工作。

It features a fully functional free trial, so you can download it and test to see if it will get your job done.

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