Foreign Key on column locked when loading from CSV

The simplest way to populate your database with test data.

Foreign Key on column locked when loading from CSV

Postby tkdennis » Tue May 13, 2008 5:01 am

I have a State table and County table, where the County table has a state_id with a foreign key back to the State table. I loaded the State data from a CSV file fine. I made a County.CSV file with the county name and state number and want to use that to load the County table, but the foreign key on state_id is locked so the counties get loaded to random states. I tried setting the table data source to the CSV, and just using CSV for the column sources, but nothing will let me change the Foreign Key Generator on state_id.

I read an old post that had this same issue and a response that it would be changed in 1.1. Is there any way to oerride the generator on a column with a Foreign Key?

SDG 1.1
Posts: 75
Joined: Fri Feb 29, 2008 12:13 am

Postby benhall » Fri May 16, 2008 3:34 pm


Thanks for your post. As I have mentioned in a previous post, the reason for 1.1 was to fix a few issues and not introduce any new features.

Thanks for your comments, at the moment this isn't possible however we are looking at incorporating this into a later release. I have added a note into our system so we can review your suggestion at a later date.

If you have any other feedback, please let us know.

Thank you

Posts: 69
Joined: Fri Dec 14, 2007 10:15 am

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests