Generate trend sequence
DMASTER
Posts: 2
Hi everyone,
Can someone help me how we can deal with the situation to mock up some predefined trend of say activity?
Assume in the database we have table Activity and for each ActivityId would like to generate ActivityLog records in predefined date range, simulating exponential increase of activities of this type, for example for 2010 - 5000 records of this type, 2011 - 7500, 2012 -some 12000, etc.
And ability to manage this trend - going up or down...
Is it possible to make something like this created with this tool?
Can someone help me how we can deal with the situation to mock up some predefined trend of say activity?
Assume in the database we have table Activity and for each ActivityId would like to generate ActivityLog records in predefined date range, simulating exponential increase of activities of this type, for example for 2010 - 5000 records of this type, 2011 - 7500, 2012 -some 12000, etc.
And ability to manage this trend - going up or down...
Is it possible to make something like this created with this tool?
Comments
Unfortunately there is not currently any canned generator we provide that can accomplish what you are attempting to accomplish.
You can request a feature for this type of generator in our forums.
http://redgatesupport.red-gate.com/foru ... -Generator
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
You could try to write your own Python script to generate data the way you want.
http://documentation.red-gate.com/displ ... tgenerator
Manfred
Product Support
Red Gate Software