SQL Server自带的导入导出功能可以导普通的属性表:
但是,如果你要复制的表中存在Geometry字段,如果用Sql server自带的导入导出表的功能将无法导入带Geometry字段的表。可以用insert into select语句将一个表中的数据复制到另一表中:
两个表在同一数据库中:
insert INTO mapping_geodata_boundary_code(code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap, supportfile_code, boundary_All)
SELECT code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap, supportfile_code, boundary_All from mapping_geodata_boundary
两个表在不同数据库中( OPENQUERY):
insert mapping_geodata_boundary
(code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap)
SELECT code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap from OPENQUERY([10.10.1.31],'select code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id,
is_thematicmap from epro30.dbo.mapping_geodata_boundary')
如果在不同的数据库中,还需要创建数据库链:
分享到:
相关推荐
简单示例实现如何为Oracle中sdo_geometry字段创建空间索引
通过Oracle提供的jar包,实现jpa方式对sdo_geometry的快速支持。
ST_Geometry及使用大全,ST_Geometry及使用大全,ST_Geometry及使用大全
Computational Geometry1 David M. Mount Department of Computer Science University of Maryland Spring 2007 Copyright, David M. Mount, 2007, Dept. of Computer Science, University of Maryland, College ...
Computational Geometry: Algorithms and Applications, 3rd ed (2008), De Berg et al. Authors: Mark de Berg, Otfried Cheong, Marc van Kreveld, Mark Overmars Publisher: Springer; 3rd edition (April 16, ...
Our first knowledge of differential geometry usually comes from the study of the curves and surfaces in $I\!\!R^3$ that arise in calculus. Here we learn about line and surface integrals, divergence ...
OO4O方式获取Oracle数据库中SDO_Geometry字段坐标方法
Geometry is the mathematical discipline that deals with the interrelations of objects in the plane, in space, or even in higher dimensions. Practicing geometry comes in very different flavors. More ...
Information geometry provides the mathematical sciences with a new framework of analysis. It has emerged from the investigation of the natural differential geometric structure on manifolds of ...
Elementary Differential Geometry.pdf Barrett O'Neill
自己写的一个js版本的由wkt转geometry插件,希望可以帮到您
Algebra Geometry - Griffiths
Geometry of differential forms
The Geometry of Syzygies
Metric Geometry.pdf
Algorithms in Real Algebraic Geometry
OCCI 方式添加Oracle数据库的多种数据字段支持,如Oracle的sdo_geometry字段。
Differential Geometry of Curves and Surfaces DoCarmo經典的微分幾何 (掃描版)
SQL空间查询ST_Geometry配置 用于arcgis进行st查询的时候的数据库进行配置
ArcSDE 配置 ST_Geometry 使用 大全