export table with a geometry column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » export table with a geometry column

export table with a geometry column

Rate Topic

Display Mode

Topic Options

Author

Message

sqlfriends

Posted Friday, February 08, 2013 10:26 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:55 PM
Points: 1,597, Visits: 2,770

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

michael.higgins

Posted Tuesday, February 12, 2013 6:07 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:43 AM
Points: 63, Visits: 469

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

This seems to have a solution

Post #1418913

sqlfriends

Posted Tuesday, February 12, 2013 10:25 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:55 PM
Points: 1,597, Visits: 2,770

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

mickyT

Posted Tuesday, February 12, 2013 11:40 AM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 1:32 PM
Points: 294, Visits: 1,101

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 Smile

Post #1419135

« Prev Topic | Next Topic »

Permissions