Referential integrity in SQL bulk copy

sqlbulkcopy

Question

My requirement is to be able to bulk insert data to multiple table. (Having foreign key constraints) I won't get the foreign keys till I submit the batch to the parent table. how to achieve this using bulk copy? i cannot use linked servers or openrowset due to policy constraints.

1
0
9/14/2011 4:19:44 PM

Popular Answer

you may be able to get away with turning off the constraints temporarily during the bulk load.

1
9/14/2011 4:26:27 PM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow