Have the possibility to get the PK and FK from CSV file

The simplest way to populate your database with test data.

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

Have the possibility to get the PK and FK from CSV file

Postby Brujah » Mon Nov 21, 2011 11:35 am

Is there a way to get the PK and FK from the CSV file
Brujah
 
Posts: 12
Joined: Wed Apr 02, 2008 10:53 am

Postby james.billings » Tue Nov 22, 2011 2:54 pm

Thanks for your post.

I wasn't quite sure what you meant here. Do you mean you would like to populate FK and PK columns with values from a CSV file? If so, I don't think you'll be able to by default, as FK's will always use the Foreign Key generator. If you drop these before you start, you can assign any generator you like to the column instead though, which may work for you?

If you mean something different, please post back with some more details!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby Brujah » Wed Nov 23, 2011 11:15 am

Yes, i would like to populate FK and PK columns with values from a CSV file?
But i don't want to drop my constrains, just want to insert the values from a CSV file with IDENTITY_INSERT ON :wink:

Is there a work around for this or can this be implemented in a future release?
Brujah
 
Posts: 12
Joined: Wed Apr 02, 2008 10:53 am

Postby james.billings » Thu Nov 24, 2011 1:11 pm

I don't think you can do it right now, without dropping the various constraints. We may already have feature requests in this area, so if we do, I'll +1 them (and if not, I'll add one)
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests