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?
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.
this is the db connection string and db creation i have:
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
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.
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.
Retrieving data ...