globally set bigint and datetime

Hi,
How can I globally set that for all Bigint and datetime data types, the default for all tables the project should be 1 thru 999,999 unique with no null ?

Date time 01-01-1901 00:00 - 01-01-1901 00:00 Randomize Time = false

which Xmls do I need to change?

Thanks,

icecurtain January 22, 2013 11:56

Comments

2 comments

The datatypes you describe are built in ones so you can't edit an XML to override them. You can create a new one though, and give it a higher score so it gets picked up. For example the BigInt one could have a file defined as this:

&lt;?xml version="1.0" encoding="iso-8859-1"?&gt;
&lt;generators&gt;
&lt;generator type="RedGate.SQLDataGenerator.Generators.Number.Int64Generator" name="MyBigInt" description="Generates BigInts" category="Generic"&gt;
   &lt;property name="MinValue"&gt;1&lt;/property&gt; 
   &lt;property name="MaxValue"&gt;999999&lt;/property&gt;	
   &lt;property name="UseSequence"&gt;False&lt;/property&gt; 
   &lt;property name="Unique"&gt;True&lt;/property&gt; 
   &lt;property name="ValidateIncrement"&gt;1&lt;/property&gt; 
   &lt;property name="NullsAllowed"&gt;False&lt;/property&gt;
   &lt;matches field="." score="999" /&gt; 
   &lt;type type="Int64" /&gt; 
  &lt;/generator&gt;
&lt;/generators&gt;

You can create a new file in C:\Program Files (x86)\Red Gate\SQL Data Generator 2\Config and the tool will pick it up. The field name matching takes a regular expression, so a . simply means "anything" - thus all fields with a bigint datatype will use this generator.

You can do a similar process to create other generators too.

James B January 23, 2013 13:23

&lt;?xml version="1.0" encoding="iso-8859-1"?&gt;
&lt;generators&gt;
    &lt;generator
        type = "RedGate.SQLDataGenerator.Generators.Number.Int64Generator"
        name = "BigInt"
        description = "Generates BigInts"
        category = "Generic"&gt;
        &lt;property name = "MinValue"&gt;1&lt;/property&gt;
        &lt;property name = "MaxValue"&gt;999999&lt;/property&gt;
        &lt;property name = "UseSequence"&gt;False&lt;/property&gt;
        &lt;property name = "Unique"&gt;True&lt;/property&gt;
        &lt;property name = "ValidateIncrement"&gt;1&lt;/property&gt;
        &lt;property name = "NullsAllowed"&gt;False&lt;/property&gt;
        &lt;matches field = "." score = "999"/&gt;

<type type = "bigint"/>

&lt;type type = "Int64"/&gt;

    &lt;/generator&gt;
&lt;/generators&gt;

works but thanks for the right direction
path = C:\Program Files (x86)\Red Gate\SQL Data Generator 1\Config

icecurtain January 24, 2013 07:58

Add comment

Please sign in to leave a comment.

How can we help you today?

globally set bigint and datetime

Comments

Add comment