![]() ![]() Simple work-flow in a convenient interface.In my opinion, the most strong points of Devart’s Data Generator are: To sum up, I would like to say that the tool has done a fantastic job for me. I chose the first option and in few seconds, I got the following population script: Open the data population script in the internal editor.Data Generator offers several ways to do that, namely: ![]() I was quite satisfied with the results showed in Preview, so I was ready to populate the target database with data. The following screenshot shows the data generation document with the result of my manipulations: I opened the Email.xml file, that is located at C:\Users\Public\Documents\Devart\dbForge Data Generator for SQL Server\Data Generators, modified regular expression so that the domain name would consist of combination of letters, updated description, name, and saved the file as MyEmail.xml: For instance, you can modify the regular expression, so that the domain name would be “” instead of “”.ĭata Generator also allows to modify existing generators and create your own ones, so in future you won’t need to modify the same generator over and over again. Email for the EmailAddress This generator is based on the following regular expression that can be customized right in the Fill settings section of Column generation settings.First Name (male) for the FirstName column.Honirific Prefix (Title) for the Title column.IDs for the ContactID Additionally, I selected the Random by timestamp value distribution mode for getting more complex numbers.Immediately preview data that will be generatedĭata Generator suggested the following generators:.Define the percentage of NULLs to be generated. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |