Red Gate forums :: View topic - Have the possibility to get the PK and FK from CSV file
Return to www.red-gate.com RSS Feed Available

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

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

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



Joined: 02 Apr 2008
Posts: 12

PostPosted: Mon Nov 21, 2011 11:35 am    Post subject: Have the possibility to get the PK and FK from CSV file Reply with quote

Is there a way to get the PK and FK from the CSV file
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Tue Nov 22, 2011 2:54 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Brujah



Joined: 02 Apr 2008
Posts: 12

PostPosted: Wed Nov 23, 2011 11:15 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Thu Nov 24, 2011 1:11 pm    Post subject: Reply with quote

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