Red Gate forums :: View topic - Export to CSV, CSV mapping
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Export to CSV, CSV mapping

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
christian harlass

Joined: 28 Oct 2011
Posts: 1

PostPosted: Fri Oct 28, 2011 1:13 pm    Post subject: Export to CSV, CSV mapping Reply with quote

I am currently evaluating the SQL Data Generator 2, got a few questions regarding the CSV part.

1) It looks like there is no way to "generate into .csv file", correct?
That would be a "nice to have" feature. For example, it could ask me for a folder, then it would generate one .csv file per table.

2) Using CSV as data source - column mapping: I have a .csv file with header (header text = column name). When I select this csv file as data source, the generators of each column remain mapped to the
default SQL Type Generator - I would expect this automatically to be reassigned to the appropriate csv column. => This is close to a showstopper for me.

3) Even when I manually assign each column to a CSV Generator, anytime I reassign a different csv file (or even the same csv file), the column mapping is reset to a SQL Generator => this is definitely a showstopper.

=> Pls let me know whether I made a mistake here or it works "as designed"
=> When "as designed" I strongly recommend to change the behavior, pls let me know if / when you'd make such a change.

Thank you very much!
Back to top
View user's profile Send private message
eddie davis

Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Mon Oct 31, 2011 11:11 am    Post subject: Reply with quote

Hi Christian

I suspect that V2.0 has introduced a bug when using a csv file as a the generator source.

I have added this forum post to a Bug Report I submitted last week to bring this issue to the attention of the development team. The reference number for the bug report is SDG-964.

I will provide an update when I get further information.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail

Joined: 13 Feb 2012
Posts: 2

PostPosted: Mon Feb 13, 2012 12:58 pm    Post subject: CSV Mapping Reply with quote


Even iam facing the same problem as Christian. When i load data into a datbase from a csv file, i assign the columns of the database to the respective columns of that csv file and data generation done properly and i saved that project.

But, when i opened that project after few minutes, i couldn't see the assigned columns in the database table with csv file and they are showing the default generators which are given by the tool itself.

Is there any way to save that columns assigned or the tool has that property or not? Please find a solution for this problem sothat the next time when we want to generate data for the tables from a same csv file, it would help and can be done in few seconds.

Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group