FEATURE PGNP 1.3.0  PGNP 1.4.0*  PGNP 1.5.0*
PostgreSQL Support 8.x, 9.x 9.x-15.x 9.x-latest
OLE DB Connection Pooling Yes Yes Yes
OLE DB Error Reporting Yes Yes Yes
OLE DB Command Prepare and Cancel Yes Yes Yes
OLE DB Columns Information Yes Yes Yes
Database Transformation in SQL Server DTSWizard Yes Yes Yes
Local Transaction Support Yes Yes Yes
Distributed Transactions and Two Phase Commit Protocol (DTC enlistment) No Yes** Yes**
SQL Server 2005-2019 Linked Servers Support Yes Yes Yes
SQL Server 2005-2019 to PostgreSQL Replication Support Yes Yes Yes
Multiple Result Sets, Multiple SQL statements/MARS From Procedures Only Full Full
Execution Tracing and Profiling PGNProfiler x86 PGNProfiler x86 PGNProfiler x64

Schema Support (tables, views, provider types, columns, primary/foreign keys,

indexes, procedures, etc.)

Yes Yes Yes
SSL, Kerberos, GSSAPI and SSPI Support Yes Yes Yes***
Extended parameters syntax support ('@', ':' and '?') Yes Yes Yes
IN, OUT and INOUT Parameters Support Yes Yes Yes
Recycling of the Internal MetaData Cache Automatic Automatic Automatic
Nested Transactions Support Yes Yes Yes
COPY Command and high-performance import support in SSIS (FastLoad) Yes Yes Yes
OLE DB Command Timeout and Cancellation  No Yes Yes
Array Types Support  No Yes Yes
IRowsetUpdate Support  No Yes Yes
Automated Product Updates Support  No Yes Yes
IDP/SSO Login support  No No Yes
Subscriptions support  No No Yes
   

 

* The PGNP v1.5 (beta) evaluation modules and documentation is provided to approved Beta Testers only. The v1.4 evaluation is available on the Download page.

** Server Edition only.

*** Pluggable/componentized.

 

Desktop Edition vs Server Edition

The above table shows common features/capabilities for both DE and SE products. The table below summarizes differences between DE and SE in the latest release.

 FEATURE Desktop Edition Server Edition
Fast and scalable (beyond 1 million rows) rows engine No Yes
Two Phase Commit Protocol (distributed transactions) Not supported Supported
Table statistics metadata Not supported Supported
Integration with linked servers/SSIS/SSRS/SSAS Minimal Full