Welcome to DATA Gen™ wiki!
How to Create Test Data using DATA Gen™
In the 1st section [Screenshot below] user has to select the Sql option. This would select the Generation Type. According to this selection the Options are decided for the different outputs.
The 2nd section is SQL Option here the user can select the data base type for which the data is to be generated. This can be done by selecting the dropdown having the label Data Base. Then user can set the table name for which the data is to be generated. There is a check box (Include CREATE TABLE) by selecting this option the Create statements will be added to the Generated data. So that when user runs the script the table gets created first and then the data is inserted into it.
The 3rd section has two fields ‚Number of Results‛ & ‚Add‛. ‘Number of Results’ field decides how many rows of data are to be generated. ‘Add’ field has a text box and an +Row(s) button, here user can increase the number of columns that is need for data generation. User will be able to add a maximum of 99 rows and a minimum of 1 row. There can be more than 500+ rows added to one Data Generation.
The 4th Section is where the details of the columns are to be set. It has multiple sections where user can set the Column Name, Data Type, Data Type, Format and Additional Data. There is another column as Examples which shows the user what type of data is to set, this would be a dummy data. The default is 50 rows.
Details about the data types and formats are explained later in this document.
Then there is a Generate button on click there will be a Popup which will show the generated data and have controls to copy the data.