Date type column generator

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Date type column generator

Postby FelipeAlvarado » Thu Aug 15, 2013 4:43 pm

I created a custom datetime generator and it works. I’m now trying to do the same for a date type column but I can't seem to find a way to make it work. What should I use for the “type” and the “sqlType”?

Thanks
FelipeAlvarado
 
Posts: 1
Joined: Thu Aug 15, 2013 4:30 pm
Location: Cd. Juarez, Mex.

Postby Brian Donahue » Mon Aug 19, 2013 9:34 am

Hi Felipe,

I believe you've solved this issue by making the generator available to the column that you want by adjusting the minlen property of the match XML element.

If you want to generate data of a certain SQL Type, it's the generator type RedGate.SQLDataGenerator.Generators.SQL.SqlColumnGenerator and the type is whatever the .NET ADO Client equivalent of the SQL data type that you need.

http://msdn.microsoft.com/en-us/library ... btype.aspx
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests