Sql data generator free5/16/2023 ![]() ![]() Being able to do that, I see SQL Data Generator as a handy tool in Software Development Lifecycle and Database Lifecycle Management processes.Īnother issue is usability. Not only can I generate data for testers to use, but I can also generate data for developers to have for their local SQL Server instances. All the other tables, lookup tables, tables not containing PII data, and so on, can be pulled in as is. The power of SQL Data Generator is the ability to target specific columns and tables to generate random data for. I didn't have to do this, so I never had the chance to capture a screenshot. You might also have other business rules, in that case, you will need to make use of Python scripts. SQL Data Generator will generate random addresses which will fail that check. Be sure the business doesn't require address verification using Melissa data. One thing to note about randomizing PII data. Random data serves no purpose it needs context. I can see their point it helps with their testing. People want the data to match production, but with all the PII data scrubbed. Side Note: What's funny is no matter where I work this is the most requested item. ![]() Another person doing the testing was hoping to use the same data set to do some manual testing. The person working on the load test told me his tests weren't going to be testing as close to production as possible. ![]() SQL Data Generator will see that column name and populate that column with a set of predefined first names.Įxcept for one little problem. Chances are you probably have a column in your database called FirstName or NameFirst. If the name matches a rule, it will instead generate pre-defined data. SQL Data Generator also looks at the column names and compares that against a rules engine. But the folks over at Redgate have thought that through. Random strings, such as AG4f3dks, are typically not very helpful. If the column is a varchar, it will generate random strings. If the column is a date, it will generate random date data. How it works is it reads the schema of the database and determines the type of data needed. Redgate's SQL Data Generator was written for this very scenario, generating data for testing. Rather than use production data, I thought this would be a good opportunity to try out Redgate's SQL Data Generator Tool. A request such as this came across my desk this week for a load test. Typically this is for two reasons, they want the volume of data to match production, or the "fake" data doesn't make any sense. At some point during the development lifecycle someone, be it a developer, QA, or a business owner, asks for "real" data to test against. ![]()
0 Comments
Leave a Reply. |