2023-06-12 14:08:48,610 INFO ogr2ogr stdout: 
2023-06-12 14:08:48,610 INFO ogr2ogr stderr: MSSQLSpatial: Use COPY/BCP: 0

ODBC: SQLDriverConnect(DRIVER={SQL Server};server=172.16.1.111;database=TCPGIS_PH1_2;uid=GISReader;pwd=GIS@2022;;UID=GISReader;PWD=GIS@2022)

OGR_MSSQLSpatial: Using column ID as FID for table Airport.

GDAL: GDALOpen(MSSQL:server=172.16.1.111;database=TCPGIS_PH1_2;uid=GISReader;pwd=GIS@2022;tables=Airport, this=00000065371055E0) succeeds as MSSQLSpatial.

GDAL: GDALDriver::Create(PostgreSQL,PG:host=localhost port=5432 dbname=tcpo_db user=postgres password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

PG: Client encoding: 'UTF8'

PG: PostGIS schema: 'public'

PG: PostgreSQL version string : 'PostgreSQL 9.5.20, compiled by Visual C++ build 1800, 64-bit'

PG: PostGIS version string : '2.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1'

PG: Could not retrieve table oid for Airport

PG: Could not retrieve table oid for airport

GDALVectorTranslate: Using FID=ID and -preserve_fid

PG: LaunderName('ID') -> 'id'

PG: LaunderName('Airport') -> 'airport'

PG: Primary key name (FID): id, type : int4

PG: Using column 'id' as FID for table 'airport'

PG: DeleteLayer(gis.airport)

PG: LaunderName('Village_Code') -> 'village_code'

PG: LaunderName('Name') -> 'name'

PG: LaunderName('Area') -> 'area'

PG: LaunderName('Dist_Code') -> 'dist_code'

PG: LaunderName('Geometry') -> 'geometry'

OGR_MSSQLSpatial: ExecuteSQL(select [ID], [Geometry_SPA], [Village_Code], [Name], [Area], [Dist_Code], [Geometry] from [dbo].[Airport])



GDALVectorTranslate: 2 features written in layer 'gis.airport'



OGR_MSSQLSpatial: 2 features read on layer 'Airport'.

ODBC: SQLDisconnect()

GDAL: GDALClose(MSSQL:server=172.16.1.111;database=TCPGIS_PH1_2;uid=GISReader;pwd=GIS@2022;tables=Airport, this=00000065371055E0)

GDAL: GDALClose(PG:host=localhost port=5432 dbname=tcpo_db user=postgres password=XXXXXXXXXX this=00000065371243D0)

GDAL: In GDALDestroy - unloading GDAL shared library.


2023-06-12 14:08:48,610 DEBUG Starting new HTTP connection (1): localhost:8080
2023-06-12 14:08:48,641 DEBUG http://localhost:8080 "GET /geoserver/rest/workspaces/tcp/featuretypes/airport/reset HTTP/1.1" 200 None
2023-06-12 14:08:48,641 INFO Layer airport reset successfully