2011

■ Upgrade from file-based (SDF or SHP) data storage to multi-user database
storage (Microsoft SQL Server, MySQL, or Oracle), which provides advanced
features, such as versioning (page 2078) and long transaction (page 2067).
■ Move joined data and calculated fields into a new data store.
■ Transform coordinate systems easily. For example, you can do any of the
following:
■ Assign a coordinate system to a data store that does not have one.
■ Create a new data store whose coordinate system is different from the
source. The target class uses the override coordinate system as the
projection for the spatial context.
■ Convert a foreign schema to a native format.
Bulk Copying To SDF Format
If you create a new SDF file (page 589) in AutoCAD Map 3D, you can use it as
a target for Bulk Copy. However, you must
delete the default schema (page
614) before copying data to the new SDF file.
Bulk Copying to SHP Format
A single SHP file can hold only one class. To copy multiple classes, to an empty
folder through the FDO SHP provider. When you copy to that connection,
Bulk Copy creates a new SHP file for each class you copy. Do not create a new
SHP file in Schema Editor and use the new SHP as your Bulk Copy target.
A SHP schema cannot be modified once it is applied.To avoid this limitation
when you copy SDF data to SHP, export the SDF schema. Then, when you
create the target SHP schema, delete its default schema and import the SDF
schema. This way, you can fix any errors in the schema. During the Bulk Copy,
select the feature class and property names in the To column and match them
exactly to the From column.
Depending on the size of the file, you can also import the SDF data and export
it as SHP.
Bulk Copying To or From SQL Server Spatial
When you copy data from an FDO-enabled SQL Server Spatial data store to a
non-FDO data store, class and property names may not be accepted by the
destination data store because naming rules vary between providers. You can
618 | Chapter 4 Managing Data