bulkinsert - SQL Server bulk insert int into bigint -

bulkinsert - SQL Server bulk insert int into bigint -

i'm trying utilize bcp utility export table disk, remove data, alter identity column on table int bigint , re-import data.

when "bcp in" info massive numbers in bigint column , not original identity. i'm using -e switch maintain identities , i've changed bcp format file it's fixedlength=4 column.

can done?

update: i'm using -n switch utilize native database types. i've tried using -w switch , different errors regarding casts , text column info types.

so reply yes can done. not appear using native info types switch -n.

i used -w switch , -t double pipe delimiter "||". needed delimiter of text values had tabs and/or pipes.

i tried batch sizes of 1000, 2500, 25000, 100000. best performance 25000.

sql-server bulkinsert bcp