Options

Matching MS SQL type "Numeric" in a customized generator.

thomasdahlthomasdahl Posts: 2
edited October 19, 2011 11:21AM in SQL Data Generator Previous Versions
Hi I'm trying to customize a Int32generator to fill data into a field of type numeric(38,0).

What type should I use in the configuration to be able to match the field

I've tried with something like:
<type type="Numeric" />
<type type="numeric" />
<type type="Numeric(38,0)" />
...

But none of those works for me.

Any suggestions?

Btw: I don't have control of the database schema so changing the field type is not an option.
· Share on Twitter

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    Thanks for your post. The below seems to work for me, although you'll need to copy your xml file into the "Config" folder for Data Generator to pick it up I think (at least, I did!)

    <?xml version="1.0" encoding="iso-8859-1"?>
    <generators>
    <generator
    type="RedGate.SQLDataGenerator.Generators.Number.Int32Generator"
    name="MyNumericGenerator"
    description="Testing!"
    category="Example">

    <property name="Increment">1</property>
    <property name="MinValue">1</property>
    <property name="MaxValue">1000</property>

    <type sqlType="Integer64"/>
    <type sqlType="Integer32"/>
    <type sqlType="Integer16"/>
    <type sqlType="Byte"/>
    <type sqlType="Numeric"/>
    </generator>
    </generators>
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.