Offset from integer
tilo23 Posts: 27
edited September 24, 2012 4:01AM in SQL Data Generator Previous Versions
May I create offset from an integer value (just as I can do this for datetime)? Currently I use trigger to update a row after insert, but maybe there is a better way?
Inside the Dilbert's world
0 · Share on Twitter
If you just want to add a set number to another number in an int field, maybe just choosing the right generator, using a custom generator, or a python generator will do the trick. Provided you don't want to add two numbers from two columns in the same table. That's still a problem for SDG. If you can be a bit more specific I can give some advice about how to do it.
Unfortunately this sort of thing is not possible at the moment, but lots of people have requested that SDG be able to extrapolate values from newly-generated data in the same column.
http://www.simple-talk.com/dotnet/.net- ... generator/
SQL Data Generator v2 has Python script embedded in it, but the config object only seems to pass data from the column that is currently being generated and you don't have access to other columns. Not sure why it has this shortcoming...
I will be evaluating the IronRuby generator in the next couple of days - will let you know if that works.
Thanks for the reply anyway.
If you ever decide to adjust the generator for the SDG 2 - please post it somewhere. It looks like a really powerful iprovement towards complicated data validity. Would save my time on writing trigger and update scripts and running several projects...
ftp://support.red-gate.com/patches/SQL_ ... .0.1.6.zip