TImportSQL

 Top  Previous  Next

This class can be used to import directly from a GIS enabled database.

MS SQL Server, Oracle and PostgreSQL ("PostGIS") all offers storage of gis data, directly inside the database.

 

We have implemented it for all three and for:

•.NET

•32/64 bit DLL

•Delphi XE7 - XE8 - 10 - 10.1 - 10.2 - 10.3 - 10.4 - 11.0.

 

You can reuse the majority of the shared properties from TImport with this class (CreateReport, NodeCount etc.).

 

This class is available with Pro only.

 

For .NET you need:

 

•GeoPackage: Microsoft.Data.Sqlite

•MS SQL: Microsoft.Data.SqlClient

•Oracle: Oracle.ManagedDataAccess.dll or Oracle.ManagedDataAccess.Core

•PostgreSQL: Npgsql.dll and npgsql.nettopologysuite

 

For the MapBasic DLL version it is all compiled into the DLL.

 

For the VCL version you need to have UniDAC Pro installed too (version 6.4.15+ is required).

 

 

 

Performance

 

Example of importing the same dataset (Brazil, 6.5 million links), from different data sources:

 

 

.NET

UniDAC (VCL)

TAB file

local

305

163 sec

GeoPackage

local

202

201 sec

MS SQL Server 2008 R2 Express

remote

275

194 sec

PostgreSQL 9.4

remote

391

329 sec

Oracle 11.2 XE

remote

1536

1422 sec

 

Full setup: Geography, Z-levels, attribute, road name, limit and external ID.