SQL Server 2008 32/64bit problem with BCP and spatial data

Posted on November 27, 2009


If you intend to BCP spatial data out of SQL Server with the intention of using BULK INSERT/BCP to deploy data to another machine you must ensure both are the same platform. You cannot BCP OUT data from a 32bit instance and BULK INSERT into a 64bit instance with spatial data.

It works fine for standard datatypes; float, int, varchar etc. This may also be an issue for other binary based data but I have only tested this with spatial (geography) data.


Posted in: sql 2008