export table with a geometry column

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  February 8, 2013 at 10:26 am

  #288960

  I tried to export data from one server to another server, they are both 2008.

  When using export wizard I got an error, cannot convert the column, the data type is geometry.

  Why is that?

  Thanks

• higgim

  SSCarpal Tunnel

  Points: 4090

  More actions

  February 12, 2013 at 6:07 am

  #1586969

  http://blog.strictly-software.com/2011/11/error-copying-tables-importing-or.html

  This seems to have a solution

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  February 12, 2013 at 10:25 am

  #1587118

  Thanks, although by changing the system file seems a workaround, I prefer to not to change it.

  I ends up to restore a database on the same server, then I am able to import that column.

  Thanks

• mickyT

  SSChampion

  Points: 10360

  More actions

  February 12, 2013 at 11:40 am

  #1587157

  Hi

  Unfortunately you are probably going to have to use some sort of workaround to solve this issue.

  Another method would be to export a query rather than the table and cast the Geometry as a varbinary(MAX). If you have a table already created as a target the binary should straight into the Geometry column. Otherwise change the SQL used to create the target table from image to Geometry.

  Hope this makes sense:-)