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: Wednesday, December 10, 2014 10:06 AM
Points: 1,792, Visits: 3,261
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: Today @ 2:09 AM
Points: 490, Visits: 1,463
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: Wednesday, December 10, 2014 10:06 AM
Points: 1,792, Visits: 3,261
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: Wednesday, December 10, 2014 12:17 PM
Points: 1,095, Visits: 3,182
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