SQL数据生成 [英] SQL Data Generation

问题描述

我在公司银行应用程序中有一个要求，其中需要在现有的MSSQL DB中生成和加载数据.它将按现有大小的x7倍加载数据库.

您能否建议我一个更好的解决方案来实现此方案.

谢谢
Arun

Hi,

I got a requirement in a corporate banking application, wherein i need to generate and load data in Existing MSSQL DB. Which will load the database by x7 times of the existing size.

Could you please suggest me a better solution to achieve this scenario.

Thanks
Arun

推荐答案

一种方法是编写自己的批量数据提取器，并对其进行转换以生成数据的多种变体.这可能是相当耗时的编写和测试.或者，您可以使用商业数据生成器.红门提供了相当不错的服务.您可以在此处获得它. .com/products/SQL_Data_Generator/index.htm"target =" _ blank"title ="新窗口> ^ ].

One way to do this is to write your own bulk data extractor and apply a transformation on it to generate multiple variations of data. This can be quite time consuming to write and test. Alternatively, you could use a commercial data generator. Red-gate provide quite a decent one; you can get it here[^].

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