You can create a SQL Server data store in native SQL Server format and you can create an extended SQL Server Spatial data store with FDO metadata.
To create a data store for SQL Server Spatial
- On the Task Pane, click either the Map Explorer or Display Manager tab.
- Click Data
Connect To Data. - In the Data Connections By Provider list in the Data Connect window, select Add SQL Server Spatial Connection).
- In the right-hand pane, enter a connection name (the name you will call this data store in AutoCAD Map 3D toolset) 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.
- Log into the service for the store, using either Windows authentication or SQL Server authentication.
- 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.
- In the Create Data Store Dialog Box 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.
- Click OK.
If the data store is created successfully, a confirmation message prompts you to edit its schema. Use the Schema Editor to create or import the schema for the data store.
The Concept tab for this topic describes issues concerning geometric and geographic properties, as well as issues with coordinate systems for SQL Server Spatial data stores.
You are connected to the new data store automatically.