Re: Extracting data from a SQL Server database

Take a look at www.freetds.org freetds allows connect to sqlserver from unix, it also comes will a tool called freebcp. I use sqh www.sqsh.org in conjuction with freetds, to gain SQL acces to sqlserver. ----- Original Message ----- From: "Neil Truby" <neil.truby@ardenta.com> To: <informix-list@iiug.org> Sent: Tuesday, May 04, 2004 11:43 PM Subject: Extracting data from a SQL Server database > My client has a series of 4GL programs that do ETL of data from various > Informix sources into a "data mart". > It works like this: a 4GL program uses synonyms to extract data from remote > live Informix databases and loads the data into a staging database. Another > set of 4GLs extract this "staging" data and insert into into the data mart. > > Now they want to add a new database to the first part: that is, the > extraction of the live data. Trouble is, this new database is a SQL Server > one. > > Any opinions on the easiest way to achieve this? > > thanks > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com > > > sending to informix-list

"Rodney Sheppard" <rod@transmit.com.au> wrote in message news:c79ig4$vji$1@terabinaries.xmission.com... > > Take a look at www.freetds.org > freetds allows connect to sqlserver from unix, it > also comes will a tool called freebcp. > I use sqh www.sqsh.org in conjuction with freetds, to gain > SQL acces to sqlserver. Thanks. But I can't open this site to find out more. Will try later. cheers Neil

"Rodney Sheppard" <rod@transmit.com.au> wrote > Take a look at www.freetds.org > freetds allows connect to sqlserver from unix I use it to move data between SQLServer and Informix (both direction) using Perl/DBI. Absolutely fabulous tool. Can't believe it is free. I strongly recommend this.