What are the challenges you face when working across database platforms? Take the survey
Options

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

thomasdahlthomasdahl Posts: 2
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.

Comments

  • Options
    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

Sign In or Register to comment.