Importing/Exporting shapefiles

Topics: Developer Forum, User Forum
Apr 25, 2007 at 4:49 PM
When you import a shapefile into SQL Server does it have to create its own table, or is there a way to just had the records to an existing table?

I have an application where users want to be able to upload and edit shapefile data. I am trying to determine what would be the best way to do this. The shapefile will relate to other data stored in a SQL Server 2000 database.

Most of the DBAs that I talk to cringe when I tell them that every time you upload a shapefile it creates its own unique table. This application could have many users uploading shapefiles, so the number of tables could grow very quickly.
Apr 25, 2007 at 7:54 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
May 7, 2007 at 9:39 PM
Is there a way to export a table to a shapefile? I see where you can import from a shapefile. Would I use the switch -export? Instead of -import.