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

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

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

Postby thomasdahl » Tue Oct 18, 2011 2:45 pm

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.
thomasdahl
 
Posts: 1
Joined: Tue Oct 18, 2011 2:36 pm

Postby james.billings » Wed Oct 19, 2011 4:21 pm

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>
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests