replica bell & ross watches
Home

replica hublot hublot replica.

PGNP OLEDB Provider for PostgreSQL, Greenplum and Redshift

PostgreSQLThe 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).
  • Support for SSRS, SSAS and SSIS.
  • 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 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
Read more...
 
PGNP Project History

September 8, 2014    Ver 1.4.0.3284

Fixed bug in determining expression type when ISNULL function is used.
Fixed bugs in handling dynamic queries in Redshift. Example: CREATE TABLE #tmp...; SELECT ... FROM #tmp; DROP TABLE #tmp;
Fix: Comment-only statement execution returned error, e.g. /* test */.
Changed column type returned from NULL to INT4.
Multiple statement did not execute or returned data in some scenarios.
Calculated column alias was not returned correctly, e.g. Select Sum(case when A>0 then X else Y end) as CalcColumn.
Fixed memory leaks.
Added new C# sample (MultipleResultsets).
Profiler: Added 64-bit applications indicator.
Profiler: Fixed missing columns on first launch after the installation.
Read more...
 
What's New in 1.4?

The new major version of the PGNP OLEDB Provider for PostgreSQL, Greenplum and Redshift has several new features and improvements:
  1. Optimizations for very large data sets (1 billion rows and more).
  2. Deferred updates support (IRowsetUpdate).
  3. Better support for Greenplum 4.x (awareness about distribution policy, better use of cursors, gpload utilization for bulk operations, etc.)
  4. Better support for PostgreSQL 9.x.
  5. New utility for Automated updates (not included in the trial build).
  6. Better integration with SSIS (MS BI tools).
Read more...
 
 
 x 
Cart empty
expensive watches replica watches.
replica omega watches
watches replica replica watches.
rolex replicas

Nouvelle Christian Louboutin Chaussures

Nouvelle Beats By Dre

Nouvelle Nike Air Jordan Chaussures

Nouvelle Nike Air Max Chaussures

Nouvelle Nike Free Run Chaussures