Autocad Fix — Sql Server Spatial

Install AutoCAD Map 3D or Civil 3D. Learn the MAPCONNECT command. Point it at your SQL Server. If you are a DBA: Create a geometry column in your asset table. Grant the AutoCAD users SELECT and UPDATE permissions on that column.

The era of exporting a DWG to SHP, then SHP to SQL, then editing, then re-exporting back to DWG is over. sql server spatial autocad

CREATE VIEW dbo.ParcelsWithArea AS SELECT ParcelID, OwnerName, Shape.STArea() AS SqMeters, Shape FROM dbo.Parcels; Connect AutoCAD to the view , not the table. Now every polygon automatically displays its calculated area. Before a surveyor saves a new boundary, a SQL Server trigger can validate the geometry: Install AutoCAD Map 3D or Civil 3D