masoud ramezani
masoud ramezani

Reputation: 22950

question about bcp utility in sql server

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?

Upvotes: 0

Views: 1267

Answers (1)

David M
David M

Reputation: 72930

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

Upvotes: 4

Related Questions