2011

Table Of Contents
In Display Manager click Data Connect to Data.
Task Pane
Bringing In Features from SQL Server Spatial
AutoCAD Map 3D supports both
SQL Server (page 323) and SQL Server Spatial.
For SQL Server Spatial, AutoCAD Map 3D supports native SQL Server Spatial
data with SQL Server 2008 SP1. If you are using SQL Server 2008, we
recommend using the SQL Server Spatial provider. While the SQL Server Spatial
provider does not read datastores created by the older SQL Server provider,
you can use
Bulk Copy (page 617) to move the data into that format.
When you view and edit features from a SQL Server Spatial data source, you
can do the following:
Use either Windows or SQL Server authentication.
Select the feature classes to include in your map.
Set conditions to limit the features in your map.
Style, theme, and edit the features.
Automatically update the data source with any edits you make.
Your edits are immediately visible to anyone else using the data source.
View and edit the schema definition.
Create a SQL Server Spatial data source.
A geographic type column is created for the geodetic coordinate system.
For other systems, a geometric type column is created. Spatial indexes are
created automatically for these geometry properties using default spatial
index parameters. You can override the defaults using the API.
You can include FDO metadata when you create a SQL Server data store.
Move other geospatial data (for example, SHP data) into SQL Server Spatial,
to take advantage of better data sharing.
NOTE If you close a drawing that uses a SQLServerSpatial connection and then
reopen that drawing, you will need to first reconnect to the SQLServerSpatial
connection and provide your user name and password. This information is not
remembered once the drawing is closed.
326 | Chapter 3 Bringing In Data