Join Gordon Luckett for an in-depth discussion in this video Loading SHP files using Bulk Copy, part of Using SQL Server Spatial with AutoCAD Map 3D.
- Using AutoCAD Map 3D you can load…existing GIS files, such as shape or STF,…into SQL Server using batch process called bulk copy.…With bulk copy, you can match the columns in the file…with those that match in the table with SQL Server.…Let's try that now.…In your exercise files folder, let's drag…and drop the PIPE_NO_PVC.shp file into your current drawing.…I'm just gonna change the colors so it's more visible…using the Style.…Close that so there's some pipe from the shp file.…
Let's connect to SQL Server.…Type in the name of my Service.…Type Login.…Pick my Data store which is actually in Nanaimo.…Copy the Data store to the Connection name.…Click Connect.…Add the pipe to my map…and then close the dialog box.…Now you'll notice there's a few pipe, the green here…is all I have in my SQL Server and I wanna basically move…all this other pipe, none of it PVC…into my current table.…
Now, during the bulk copy process,…I can take any two vector based data sources,…so if I go back in the Data, Connect to Data,…anything in here so basically ArcSDE,…
Released
4/1/2015Before you begin this course, we recommend watching AutoCAD Map 3D Essential Training for a solid understanding of the program.
Share this video
Embed this video
Video: Loading SHP files using Bulk Copy