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!
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
Is there a work around for this or can this be implemented in a future release?
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)
Brujah
Posts: 22 Bronze 2
Comments
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!
Redgate Software
But i don't want to drop my constrains, just want to insert the values from a CSV file with IDENTITY_INSERT ON
Is there a work around for this or can this be implemented in a future release?
Redgate Software