Info, examples and downloads for 'PostgreSQL OLE DB Provider'. Attempting to connect to a database running version 7.3.x or down will result in an error. FEATURE PGNP 1.2. Quest sql optimizer for oracle keygen generator adobe photoshop. 8 PGNP 1.3.0 PGNP 1.4.0* PostgreSQL Support 8.0 8.x, 9.x 8.x-10.x 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. June 21, 2018 Ver 1.4.0.3522 Added support for querying very large rowsets via 'single row mode' cursor. Fixed bug in handling Postgres 10 'partitioned' tables. Profiler: Added code to display filtration progress. Profiler: Enabled cancellation of filtration. March 31, 2018 Ver 1.4.0.3516 Installer: Added checkbox that enables launching PGNPUpdate utility after the installation completion. Fixed bugs in handling INSERT INTO OPENQUERY, UPDATE FROM OPENQUERY, and DELETE FROM OPENQUERY for linked servers. ![]() The new major version of the PGNP OLEDB Provider for PostgreSQL, Greenplum and Redshift 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 tools). 1 2014 PGNP Native OLE DB Provider for PostgreSQL, Greenplum, Redshift Developer s Manual This document contains description of various PGNP features, use cases and programming techniques. It is written for professional developers. Konstantin Izmailov Copyright All Rights Reserved. 5/9/2014 2 This document is property of PGNP team. Neither a part nor the entire document can be reproduced, changed, distributed or published without prior written permission of owners. ![]() 7 2 Installation and Product Activation To install the PGNP OLEDB Provider launch the installation module. The Module name may vary depending on the provider variant/edition: Module name PGNP-Postgres-DE exe PGNP-Postgres-SE exe PGNP-Greenplum-DE exe PGNP-Greenplum-SE exe PGNP-Redshift-SE exe Description OLEDB Provider for Postgres, Desktop Edition OLEDB Provider for Postgres, Server Edition OLEDB Provider for Greenplum, Desktop Edition OLEDB Provider for Greenplum, Server Edition OLEDB Provider for Redshift Note: Evaluation module name includes word trial, e.g.: PGNP-Postgres-DE-Trial exe. First page of the installation application is shown below. Click Next through the wizard pages. Please read the License Agreement carefully. Specify the installation folder. By default, the Postgres and Greenplum providers are installed into C: Program Files (x86) intellisoft pgnp folder, and the Redshift into C: Program Files (x86) intellisoft rsnp folder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |