bcp -n -E fails on identity column
John Kendall <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Using the bcp -n (native file format) and -E (retain identity values) options together produces:
Msg 20053, Level 4
Requested data conversion does not exist
I see this happening on Sybase (11 & 16) and MS SQL 2008.
Test to reproduce:
select id_col=identity(5) into tempdb..tbl -- Sybase
select id_col=identity(int) into tempdb..tbl -- MS SQL
$ freebcp tempdb..tbl out tbl.bcp -S $DSQUERY -U usr -P pw -n -E
Starting copy...
Msg 20053, Level 4
Requested data conversion does not exist
bcp copy out failed
datacopy also has a problem with the -E option, I assume the problems are related.
John