Post reply

export table with a geometry column

  • 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

  • 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

  • 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

  • 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:-)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply