question about bcp utility in sql server

Question

If I have data rows in database and want to import data from data file with bcp utility in native mode, is there any solution (specified switch) that override data with same identity value in ID column?

Answer 1

Yes - -E to keep identity values in the file. Just type bcp at the command line to see a full list of options.