Data can also be drawn from a list in a text file. If you have some proprietary data that cannot be randomly generated, there is a "SQLColumn" data generator that will draw data from another database, based on a SELECT statement. The offset can be days, or just hours and minutes.
#Sql data generator online software#
The software will generated a Date Added, within a specified range, then also generate a Date Modified column based on an offset from the Date Added column. In my work, the best examples of dependent columns are the Date Added and Date Modified columns. (I was also pleased with how responsive they were to people on their boards). SQL Data Generator can also generate columns based on other columns, something that several people on their boards for the beta requested. Figure 1 demonstrates how I inserted a value from the Date Added column, and also shows the regular expression for the data in the Access Number column. With one click you can add values from other columns in the target table. The final release version of the tool, which I recently downloaded, has a powerful extension to the regular expression generator. That's very flexible and easy.Īs you would expect, there's also an all-purpose regular expression generator for custom expressions. Many of these default "generators", as they are called, are built from regular expressions, and the expressions can be edited in the same dialog in which they are chosen. All of these data types, and plenty more, are provided right out of the box (and that's in a beta!). Some of the fields I need to generate include date added and modified, phone numbers, GUIDs, OS types, and various integers keyed to look up tables. At least half the beta software out there never gets that far.
I was more than pleasantly surprised that the beta release installed and launched perfectly. There are several products out there, so I applied my usual snap judgment questions: how much? Does the product or the web site look like 1998? Does it require a scientist? Is there more than one screen shot? Fortunately after this exacting first cut, I found that Red Gate had just put out a beta of a new product, SQL Data Generator. This time I decided to search the web (again) for some product to perform this difficult and esoteric task. I've done this more or less manually in the past and found that it's practically impossible to generate realistic ISP and VPN session data without spending a couple days writing and tweaking SQL scripts. I recently needed to generate thousands of test session records for our enterprise VPN management product.
0 kommentar(er)
