Support for MS SQL Server 2000/2005

Status: Beta

Brought to you by: gaffie

Support for MS SQL Server 2000/2005

Forum: Feature Request

Creator: Nobody/Anonymous

Created: 2005-11-11

Updated: 2013-03-27

Nobody/Anonymous - 2005-11-11

Would be nice..

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous - 2007-09-25
  
  I need to ETL a whole lot of data from MS SQL Server 2005 to Oracle. I see that Pequel supports fast loading into Oracle. Can it extract data from SQL Server 2005? It seems like it would be possible if Pequel could just use DBI to extract from SQL Server, which seems simple, but I don't see anywhere on the documentation that this is supported. I just see Oracle and Sqlite only. Will Pequel work for what I need to do?
  
  Thanks,
  Ryan
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Nobody/Anonymous - 2007-09-25
  
  Please take a look at the new Pequel 3 release test scripts in the t/ directory. These scripts demo how to connect to DBI
  
  t/11-section-input-datasource-dbi.t
  t/11-section-input-join-datasource-dbi.t
  t/11-tables-datasource-dbi-2.t
  t/11-tables-datasource-dbi.t
  
  Note that Pequel3 is not compatible, and somewhat different to pequel2 -- the Oracle and Sqlite c-code gen is no longer available; instead there is a new Datasource/Dataset facility which is easily configurable and extendable.
  
  Hope this helps
  
  M
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.