Conversion failure on data generation

The simplest way to populate your database with test data.

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

Conversion failure on data generation

Postby kspencer@solidq.com » Tue Jul 03, 2012 8:28 pm

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.
Ken Spencer
SolidQ
kspencer@solidq.com
 
Posts: 1
Joined: Tue Jul 03, 2012 8:25 pm

Postby Brian Donahue » Thu Jul 05, 2012 9:59 am

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu Jul 05, 2012 10:01 am

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
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