|
PGNP Features Matrix (32- and 64-bit Platforms) |
| | PGNP 1.2.8
| PGNP 1.3.0 | PGNP 1.4.0* | | PostgreSQL 8.x Support | Yes | Yes | Yes | | 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 2000, 2005 and 2008 Linked Servers Support | Yes | Yes | Yes | | SQL Server 2000, 2005 and 2008 to PostgreSQL Replication Support | Yes | Yes | Yes |
Multiple Result Sets, Multiple SQL statements/MARS
| From Procedures Only | From Procedures Only | Full | | Execution Tracing and Profiling | TraceMgr | PGNP Profiler
| PGNP Profiler | Schema Support (tables, views, provider types, columns, primary/foreign keys, indexes, procedures, etc.) | Yes | Yes | Yes | | SSL, Kerberos, GSSAPI and SSPI Support | No | 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 | Manual ** | Automatic | Automatic | 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 |
