I used a for loop to loop through multiple directories where shapefiles are saved and print them. I need to therefore import these shapefiles to a mssql db. How do i achieve this?
Hi Joshua,That article by Alastair you suggested helped quite a lot, managed to get around the problem and can import to sql using commands he covers in it.
What we're trying to do is cut out the process of loading 500Gb + of shapefiles every quarter to ArcGIS and from that to creating a sql db as a last stop as this was done manually. I'm going to read up on that article, hope it helps.
Thanks a lot Josh.
If you want to use ArcGIS to load the data, you will need to Create Database Connection—Help | ArcGIS Desktop.
If you simply want to load shape files into SQL Server and you are unfamiliar with ArcGIS, I suggest reading "Importing Data to SQL Server" section of OGR2OGR Patterns for SQL Server | Alastair Aitchison
this is the db connection string and db creation i have:
It starts with understanding Database connections in ArcMap—Help | ArcGIS Desktop. You will need to create a database connection file to the MSSQL DB, so Esri tools can work with it.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
