Conversion failure on data generation

kspencer@solidq.com

I tried out this tool today and it blows up consistently on one table.

The error says conversion failed from varchar to in with the data 6/12.

But it does not tell me the column it tailed on so i can't track it down.

Brian Donahue

Hi Ken,

As far as I'm aware, SDG is not going to cast or convert any data, so my best guess is that the column in question would probably be a computed column. Data Generator will still allow SQL Server to generate the data for any computed columns rather than attempting to generate it itself.
http://www.red-gate.com/supportcenter/c ... generators

Brian Donahue

SQL Server's syscolumns table will make it easier to find any computed columns using the IsComputed column. http://msdn.microsoft.com/en-us/library/ms186816.aspx