Sql Server Spatial Autocad

**Additional Resources** ----------------------

* **Method 2: Use AutoCAD's .NET API to read data from SQL Server and draw it in AutoCAD** sql server spatial autocad

CREATE TABLE MySpatialTable ( ID INT PRIMARY KEY, Shape GEOMETRY ); GO No other user can edit that feature until you save

Before a surveyor saves a new boundary, a SQL Server trigger can validate the geometry: Shape GEOMETRY )

An AutoCAD DWG file contains visual entities: Line , Polyline , Circle , Block Reference . SQL Server requires Well-Known Text (WKT) or Binary (WKB). Out-of-the-box, vanilla AutoCAD does not speak to SQL Server.

How? AutoCAD Map 3D's FDO provider supports . When you select a parcel, AutoCAD checks out a lock via SQL Server's sp_getapplock . No other user can edit that feature until you save.

Use the AutoCAD Spatial Tools to import your CAD data into the SQL Server Spatial database. You can do this by selecting the CAD entities and using the "Export to Spatial Database" tool.