Home Products » Features Matrix
PGNP Features Matrix (32- and 64-bit Platforms)
 PGNP 1.2.8
 PGNP 1.3.0  PGNP 1.4.0*
PostgreSQL 8.x SupportYesYesYes
OLE DB Connection PoolingYesYesYes
OLE DB Error Reporting Yes YesYes
OLE DB Command Prepare and Cancel YesYes Yes
OLE DB Columns Information YesYesYes
Database Transformation in SQL Server DTSWizard YesYes Yes
Local Transaction SupportYesYesYes
Distributed Transactions and Two Phase Commit Protocol (DTC enlistment)NoYesYes
SQL Server 2000, 2005 and 2008 Linked Servers SupportYesYesYes
SQL Server 2000, 2005 and 2008 to PostgreSQL Replication Support Yes YesYes
Multiple Result Sets, Multiple SQL statements/MARS
From Procedures OnlyFrom Procedures OnlyFull
Execution Tracing and Profiling TraceMgr PGNP Profiler
PGNP Profiler

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

indexes, procedures, etc.)

YesYes Yes
SSL, Kerberos, GSSAPI and SSPI SupportNoYes Yes
Extended parameters syntax support ('@', ':' and '?')YesYes Yes
IN, OUT and INOUT Parameters SupportYesYes Yes
Recycling of the Internal MetaData Cache Manual ** AutomaticAutomatic
OLE DB Command Timeout
 No Yes Yes
Array Type Support
 No Yes Yes
Nested Transactions Support
 No Yes Yes
COPY Command and high-performance import support in SSIS
 No Yes Yes
IRowsetUpdate Support
 No No Yes
Automated Product Updates Support
 No No Yes

* Evaluation version and documentation are available on the Download page.

** The internal stored procedure pgnp_refreshmetadata allows recycling of internal metadata cache in all connected instances of the provider. See Developer's Manual for more information.

Last Updated on Tuesday, 08 November 2011 08:32
Cart empty