title: SQL Server bulk insert int into bigint
body: <p>I'm trying to use the bcp utility to export a table to disk, remove the data, change the identity column on that table from int to bigint and then re-import that data.</p>
  
  <p>When I "bcp in" the data I get massive numbers in the bigint column and not the original identity. I'm using to -E switch to keep identities and i've changed the bcp format file so that it's a fixedlength=4 column.</p>
  
  <p>Can this be done?</p>
  
  <p>UPDATE: I'm using the -N switch to use native database types. I've now tried using the -w switch and now I get a different errors regarding casts and text column data types.</p>