The simplest way to populate your database with test data.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr
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”?
- Posts: 1
- Joined: Thu Aug 15, 2013 4:30 pm
- Location: Cd. Juarez, Mex.
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
- Posts: 6669
- 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