Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

export table with a geometry column Expand / Collapse
Author
Message
Posted Friday, February 8, 2013 10:26 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:18 AM
Points: 1,787, Visits: 3,241
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
Post #1417822
Posted Tuesday, February 12, 2013 6:07 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 3:52 AM
Points: 449, Visits: 1,370
http://blog.strictly-software.com/2011/11/error-copying-tables-importing-or.html

This seems to have a solution
Post #1418913
Posted Tuesday, February 12, 2013 10:25 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:18 AM
Points: 1,787, Visits: 3,241
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
Post #1419090
Posted Tuesday, February 12, 2013 11:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:48 PM
Points: 1,057, Visits: 3,127
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
Post #1419135
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse