Read data from SQL Server 2008 (Windows) to Informix in Unix
The poster wanted to copy data from SQL Server 2008 on Windows into an Informix database on HP-UX and asked how. Suggestions offered: use FreeTDS plus sqsh to talk to SQL Server from Unix; install ODBC on HP-UX and drive both databases from a Perl/PHP/Python script (with IBM's own Informix ODBC driver suggested as a free alternative to DataDirect); or write a Java program using Microsoft's JDBC driver for SQL Server (or a JDBC-ODBC bridge) to connect to both servers and move the data. The poster never reported which approach he chose, so no confirmed resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I need to read several tables in a database Informix in Unix (HP-UX) from SQL Server 2008 It means: Source : SQL Server 2008 (Windows) Target : Informix in Unix Is there some way of doing this ? Thanks in advance for any clues that you could provide me Best regards
"Peternt" <roger_vilca@yahoo.es> wrote in message news:b1f0d41c-e22c-4d70-acbb-e3a2840392bb@g19g2000yqc.googlegroups.com... > Hi, > I need to read several tables in a database Informix in Unix (HP-UX) > from SQL Server 2008 > It means: > Source : SQL Server 2008 (Windows) > Target : Informix in Unix > > Is there some way of doing this ? > Thanks in advance for any clues that you could provide me > Google freetds and sqsh
You could install ODBC on HP-UX and then use Perl/PHP/Phython to connect to both databases at once and copy the data as needed. HTH, -D On Jun 30, 2010, at 8:42 PM, Peternt wrote: > Hi, > I need to read several tables in a database Informix in Unix (HP-UX) > from SQL Server 2008 > It means: > Source : SQL Server 2008 (Windows) > Target : Informix in Unix > > Is there some way of doing this ? > Thanks in advance for any clues that you could provide me > > Best regards > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list
On 30 jun, 23:10, D <kingslacker...@gmail.com> wrote: > You could install ODBC on HP-UX and then use Perl/PHP/Phython to connect to both databases at once and copy the data as needed. > HTH, > -D > > On Jun 30, 2010, at 8:42 PM, Peternt wrote: > > > Hi, > > I need to read several tables in a database Informix in Unix (HP-UX) > > from SQL Server 2008 > > It means: > > Source : SQL Server 2008 (Windows) > > Target : Informix in Unix > > > Is there some way of doing this ? > > Thanks in advance for any clues that you could provide me > > > Best regards > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list What products ODBC for HP-UX do you recommend ? I know the DataDirect, is there another option ?
Peternt wrote: > > What products ODBC for HP-UX do you recommend ? > I know the DataDirect, is there another option ? What's wrong with IBM Informix's driver? The price is certainly unbeatable. :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
You have a couple of ways of doing this. The easiest would probably do this all in java and use Microsoft's JDBC Driver for SQLServer... http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en I think Sun er Oracle has a jdbc-odbc bridge that would also work too. Then it doesn't matter where you run your app you just connect to both servers and move the data. HTH -G > From: roger_vilca@yahoo.es > Subject: Re: Read data from SQL Server 2008 (Windows) to Informix in Unix > Date: Thu, 1 Jul 2010 09:08:55 -0700 > To: informix-list@iiug.org > > On 30 jun, 23:10, D <kingslacker...@gmail.com> wrote: > > You could install ODBC on HP-UX and then use Perl/PHP/Phython to connect to both databases at once and copy the data as needed. > > HTH, > > -D > > > > On Jun 30, 2010, at 8:42 PM, Peternt wrote: > > > > > Hi, > > > I need to read several tables in a database Informix in Unix (HP-UX) > > > from SQL Server 2008 > > > It means: > > > Source : SQL Server 2008 (Windows) > > > Target : Informix in Unix > > > > > Is there some way of doing this ? > > > Thanks in advance for any clues that you could provide me > > > > > Best regards > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list > > What products ODBC for HP-UX do you recommend ? > I know the DataDirect, is there another option ? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5