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.

 

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

MS SQL: Microsoft.SqlServer.Types.dll

Oracle: Oracle.ManagedDataAccess.dll

PostgreSQL: Npgsql.dll (tested with version 3.1.10)

 

For the 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

221

180 sec

MS SQL Server 2008 R2 Express

remote

234

211 sec

PostgreSQL 9.4

remote

292

243 sec

Oracle 11.2 XE

remote

2983

1580 sec

 

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