5/3/2023 0 Comments Dbforge data generator![]() You need to populate the test database with help of the data generator. There is an empty test database without data. You run a tool that masks data in specified columns, with a specified algorithm in the same database.Ģ. There is a copy of the production database. What a use case is applicable in your situation:ġ. If we understand you correctly, you need the data masking functionality. Click the Generator button and add 2 or more generators to the RegExp editor window.ĥ) Here is the code for the Python generator (for 3rd column): In the future, we are going to add the option that allows you to specify a data source - either parent table values or random values.Ĥ) To combine several generators, you need the following: Alternatively, you can use the Table or View generator. You can specify a linked table and a column there. ![]() Please specify what did you mean by data refresh?Ģ) What condition do you use to generate data for the linked table? You can set the following values manually:įor date_3, you can specify a period (in the date generator) between date_1 and date_2 - date_3 = from 1973 to 1982ģ) You need to use the FK generator for this purpose. It is possible to truncate the table and generate a completely new data set. I have a date field in one table, ideally this should be populated with a date which is between 2 dates in a related table, can I create a SQL query which references a field in the record being created?Īny help on these would be greatly appreciated.ġ) Data Generator adds new data to the existing one. How do I assign multiple generator types to one field?ĥ. I have a column which is an address, but without the postcode. How do I setup to insert multiple records based on the foreign key? (I could create separate datasets of these records which I could randomly pick one of.)Ĥ. The content of the records will be different based on these bit flags. I have a related table to this which will have multiple records. I have three bit fields, if either of the first two are true, then the third must be false. (if I can do this, then the below questions should not be needed).Ģ. I have the option to start from some live data, is there a way to perform updates and not inserts? it would make life for me much easier and also allow me to create more realistic dev/test data. I am using the Data Generator on my first non-trivial database and I have a few questions.ġ.
0 Comments
Leave a Reply. |