topic Re: Importing Shapefiles to a mssql db in Geodatabase Questions

Importing Shapefiles to a mssql db

TshepoHlako — Thu, 07 Feb 2019 07:42:06 GMT

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?

Re: Importing Shapefiles to a mssql db

JoshuaBixby — Thu, 07 Feb 2019 17:10:29 GMT

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.

Re: Importing Shapefiles to a mssql db

TshepoHlako — Fri, 08 Feb 2019 06:29:13 GMT

this is the db connection string and db creation i have:

Re: Importing Shapefiles to a mssql db

JoshuaBixby — Fri, 08 Feb 2019 15:19:32 GMT

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

Re: Importing Shapefiles to a mssql db

TshepoHlako — Mon, 11 Feb 2019 06:23:30 GMT

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.

Re: Importing Shapefiles to a mssql db

TshepoHlako — Mon, 18 Feb 2019 12:29:55 GMT

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.