MS_SQL Connectivity

[Shawn Tayler]

On Thu, 17 May 2007 21:15:08 -0700 Bill Campbell <linux-sxs at celestial.com>
exclaimed:

> >> Have you tried JDBC drivers ( which require you to use Java ) ? There
> >> are many jdbc drivers for mssql and postgresql. 
> >> 
> >> Vu  
> >
> >Thanks Vu,
> >
> >But I really know nothing of Java.  
> 
> You don't need to know much about java to use most jdbc drivers
> (and they're probably the best to use with OpenPKG given its Sun
> and Java heritage).  Mostly it depends on what's going to be
> using the interface.
> 
> Bill

Hi Bill,

Well, my intention is to either run a query every 24 hours that pulls the
past days data from probably one or 2 tables on each server.  this data is
dup checked, cleaned up, and inserted into a set of tables in the Postgre
box. The other option is to have the tables in question, which are present
in the remote MS-SQL boxes, appear as tables in the PostgreSQL server.
Either would be helpful to my purpose.

Shawn