2011

Table Of Contents
the WKT to the Mentor version. The WKT specified in the file takes precedence
over the WKT in the SQL Server catalog.
NOTE This functionality affects geospatial feature data only. For information about
linking records in an external database to objects in a drawing, see
Overview of
Linking Database Records to Objects
(page 522). For information about moving
data between DWG and geospatial formats, see
Migrating DWG Data to GIS (page
628).
To create a data store for SQL Server Spatial
1 On the Task Pane, click either the
Map Explorer (page 2068) or Display
Manager
(page 2060) tab.
2 Click Data Connect To Data.
3 In the Data Connections By Provider list in the Data Connect window,
select Add SQL Server Spatial Connection).
4 In the right-hand pane, enter a connection name (the name you will call
this data store in AutoCAD Map 3D) and the information required to
connect to the data store, for example, a service name.
NOTE Do not use the same name you used when you created a user for the
data store
(page 584).
5 Log into the service for the store, using either Windows authentication
or SQL Server authentication.
6 In the Data Store list, select Add New Data Store (or type a name that
does not appear in the list already) and press Enter.
You are asked if you want to create a new data store. Click Yes.
7 In the Create Data Store Dialog Box (page 1747) for this provider, enter the
settings for the new data store.
Specify whether the new data store will be FDO-enabled or not by selecting
or clearing Use FDO Enabled Schema. FDO-enabled data stores include
additional FDO metadata, but otherwise use native SQL Server schema
capabilities.
8 Click OK.
If the data store is created successfully, a confirmation message prompts
you to edit its schema. Use the Schema Editor to create (page 596) or import
(page 606) the schema for the data store.
592 | Chapter 4 Managing Data