2011

Insert Errors
Select this option to continue Bulk Copy if there is an error inserting an
object. Objects that fail are skipped. Errors can occur if there are any
anomalies in the object data being copied.
Anomalies can include an unmatched feature ID, a value that is outside the
range allowed for a property, a constraint violation (for example, each item
must be unique and the source is trying to copy over an object that already
exists in the target), or an inappropriate value (for example, a string value
that is too long).
Unmatched Data Or Geometric Type Errors
Select this option to skip association and object properties that the target
data store does not support.
NOTE AutoCAD Map 3D does not support either association or object properties,
but they may be present in existing schemas created outside AutoCAD Map
3D.
Some dimension properties are also skipped. For example, if you copy 3D
data to a 2D target, the z-coordinate is silently removed. Some fields can
be converted, for example, from int32 to int64, from int32 to double, or
from int32 to string. However, if a target does not support a data type (for
example, blob or polygon geometry), the data cannot be converted and the
object is skipped.For information about how fields are converted, see
Understanding How Bulk Copy Converts Data Types (page 623).
When the geometry coordinate system is Lat/Long, SQL Server Spatial
considers the inside of a polygon to be to the left of the outer boundary. If
a polygon with a clockwise boundary is inserted, the polygon actually covers
the rest of the world, excluding what appears to be inside the polygon from
an onscreen perspective. If you check Unmatched Data Or Geometric Type
Errors as an error type to ignore, the geometry and orientation are adjusted
when the target is SQL Server Spatial. If you do not check this option and
you copy a polygon with the wrong orientation to SQL Server Spatial, that
object will fail to copy.
Coordinate System
Select this option to copy the geometry without performing a coordinate
system transformation, for example, if information for the source or target
coordinate systems is missing, but you are sure that the geometry coordinate
systems are the same. If you are not sure of one of the coordinate systems,
this option can produce undesired results.
For example, if you are missing the .PRJ file for the .SHP file you are copying,
but you know that the coordinate system is the same as the target, use this
option.
1746 | Chapter 26 Managing Data Dialog Boxes