 The PGNP provider is a thin layer between Microsoft ADO and PostgreSQL database. It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database. The provider can be used from 32-bit and 64-bit applications both native and .NET.
Main features are: - Database conversion with DTS Wizard (MSSQL 2000) or SSIS Wizard (MSSQL 2005/2008/2012).
- SQL Server Linked Servers and Replication support.
- Error reporting and execution tracing.
- Transactions support: standard OLEDB, and "nested" PostgreSQL transaction using savepoints.
- Distributed transactions (two phase commit protocol).
- Schema support for tables, views, provider types, columns, primary/foreign keys, indexes, etc.
|
|
Read more...
|
| | 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 |
|
|
Read more...
|
|
May 15, 2013 Ver 1.4.0.3152More changes made to fix error: "COPY file signature not recognized".
May 14, 2013 Ver 1.4.0.3150Fixed bug that caused the error during bulk insert: "COPY file signature not recognized".
Fixed bug when execution of some queries resulted in the error "Cannot insert multiple commands into a prepared statement".
Made stability fix in Profiler, and added logging for Guid parameter.
April 26, 2013 Ver 1.4.0.3146Resolved "SSL renegotiation issue" when connection was breaking after large volume of data transferred.
Fixed bug in FastLoad causing "incorrect binary data format" error for types date and time.
|
|
Read more...
|
|
|
The new major version of the PGNP OLEDB Provider for PostgreSQL and Greenplum has several new features and improvements:
- Optimizations for very large data sets (1 billion rows and more).
- Deferred updates support (IRowsetUpdate).
- Better support for Greenplum 4.x (awareness about distribution policy, better use of cursors, gpload utilization for bulk operations, etc.)
- Better support for PostgreSQL 9.x.
- New utility for Automated updates (not included in the trial build).
- Better integration with SSIS (MS BI tool).
|
|
Read more...
|
|
|