Import Shapefiles to SQL Server

import.bat

@echo off

set osgeopath="C:\OSGeo4W64\bin"
set basepath="C:\Users\{username}\Downloads\Esri"

rem echo %osgeopath%
rem echo %basepath%

cd "%basepath%\GIS_Data_&_Maps_CD1[World_Europe]\europe\basemap"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_europe_basemap; Trusted_Connection=yes" "%%f"

cd "%basepath%\GIS_Data_&_Maps_CD1[World_Europe]\europe\demogrph"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_europe_demogrph; Trusted_Connection=yes" "%%f"

cd "%basepath%\GIS_Data_&_Maps_CD1[World_Europe]\europe\germany"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_europe_germany; Trusted_Connection=yes" "%%f"

cd "%basepath%\GIS_Data_&_Maps_CD1[World_Europe]\world"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_world; Trusted_Connection=yes" "%%f"

cd "%basepath%\GIS_Data_&_Maps_CD2[Canada_Mexico_USA_World]\canada"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_canada; Trusted_Connection=yes" "%%f"

cd "%basepath%\GIS_Data_&_Maps_CD2[Canada_Mexico_USA_World]\mexico"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_mexico; Trusted_Connection=yes" "%%f"

cd "%basepath%\GIS_Data_&_Maps_CD2[Canada_Mexico_USA_World]\usa"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_usa; Trusted_Connection=yes" "%%f"

cd "%basepath%\GIS_Data_&_Maps_CD3[USA_Continued]\usa"
for %%f IN (*.shp) DO %osgeopath%\ogr2ogr.exe -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database=esri_usa_xtra; Trusted_Connection=yes" "%%f"

cd "%basepath%"

import.md

https://coderwall.com/p/v_nrig/importing-a-shapefile-into-sql-server-2012

Local database on your localhost or using a user thats on some windows domain:

"C:<location of ogr2ogr>\ogr2ogr.exe" -overwrite -f MSSQLSpatial "MSSQL:server=;database=;trusted_connection=yes" "C:<path to shapefile><Shapefile>.shp"

Remote database (like on Azure, etc):

"C:<location of ogr2ogr>\ogr2ogr.exe" -overwrite -f MSSQLSpatial "MSSQL:server=;database=;Uid=;pwd=;Driver={SQL Server Native Client 11.0}" "C:<path to shapefile><Shapefile>.shp"

for %%f IN (*.shp) DO C:\OSGeo4W64\bin\ogr2ogr.exe" -overwrite -f MSSQLSpatial "MSSQL: Driver={SQL Server Native Client 11.0}; Server=localhost; Database={your_dbname}; Trusted_Connection=yes" "%%f"

makevalid.sql

use [esri_canada];
update [areacode] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [indnrsrv] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [mdcities] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [mjcities] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [mjrroads] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [municplt] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [natlpark] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [postal] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [province] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [provpark] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [rails] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [regnmuni] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [water] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;

use [esri_europe_basemap];
update [canals] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cities] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [mjroads] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [mjwater] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [places] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [province] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [rails] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [roads] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [urban] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [water] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;

use [esri_europe_demogrph];
update [country] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [demog] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [purpower] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [regions] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;

use [esri_europe_germany];
update [plzzip1] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [plzzip2] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [plzzip5] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;

use [esri_mexico];
update [cities] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [drainage] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [lakes] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [rivers] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [roads] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [roads_rt] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [states] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;

use [esri_usa];
update [adi] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [airports] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [areacode] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cd106] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cities] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cities_dtl] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cities_reprojected] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [counties] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [dma] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [drainage] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [fedlandl] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [fedlandp] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [hydroln] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [hydroply] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [intrstat] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [lakes] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [majrdnet] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [mjrrds] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [msa] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [parks] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [placeply] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [places] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [publdsur] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [quakehis] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [rivers] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [roads] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [roads_rt] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [spcszn27] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [spcszn83] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [states] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [states_reprojected] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [topoq100] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [topoq24] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [topoq250] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [urban] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [urban_dtl] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [volcano] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [zip_usa] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [zip3] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;

use [esri_usa_xtra];
update [airports] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [dtl_st] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [gchurch] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [ggolf] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [ghospitl] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [gppl] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [gschools] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [gsummit] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [highways] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [institut] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [lalndmrk] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [mjwater] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [parks] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [rail100k] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [recareas] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [retlcntr] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [tracts] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [tranterm] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [usroute] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [zip_poly] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;

use [esri_world];
update [admin00] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cities] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cntry00] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [cntry92] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [continent] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [country] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [drainage] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [gaz] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [geogrid] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [lakes] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [latlong] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [region] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [rivers] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [timezone] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [utmzone] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [world30] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;
update [wwf_eco] set ogr_geometry = ogr_geometry.MakeValid() where ogr_geometry.STIsValid() = 0;