Read data from SQL Server 2008 (Windows) to Informix in Unix

FAQ

Profile

Read data from SQL Server 2008 (Windows) to Informix in Unix

Database Forums (Home) -> Informix

Next: Detect Valid Full backup

Author

Message

Peternt

External

Since: Jun 30, 2010
Posts: 2

(Msg. 1) Posted: Wed Jun 30, 2010 5:42 pm Post subject: Read data from SQL Server 2008 (Windows) to Informix in Unix Archived from groups: comp>databases>informix (more info?)

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 >> Stay informed about: Read data from SQL Server 2008 (Windows) to Informix in Unix

External

Since: Jul 01, 2010
Posts: 1

(Msg. 2) Posted: Thu Jul 01, 2010 12:10 am Post subject: Re: Read data from SQL Server 2008 (Windows) to Informix in Unix [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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.DeleteThis@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >> Stay informed about: Read data from SQL Server 2008 (Windows) to Informix in Unix

Rodney Sheppard

External

Since: Dec 05, 2003
Posts: 2

(Msg. 3) Posted: Thu Jul 01, 2010 12:26 am Post subject: Re: Read data from SQL Server 2008 (Windows) to Informix in Unix [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

"Peternt" wrote in message > 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 >> Stay informed about: Read data from SQL Server 2008 (Windows) to Informix in Unix

Peternt

External

Since: Jun 30, 2010
Posts: 2

(Msg. 4) Posted: Thu Jul 01, 2010 9:08 am Post subject: Re: Read data from SQL Server 2008 (Windows) to Informix in Unix [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On 30 jun, 23:10, D 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....RemoveThis@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 ? >> Stay informed about: Read data from SQL Server 2008 (Windows) to Informix in Unix

Obnoxio The Clown

External

Since: Jan 05, 2008
Posts: 79

(Msg. 5) Posted: Thu Jul 01, 2010 12:25 pm Post subject: Re: Read data from SQL Server 2008 (Windows) to Informix in Unix [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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. ) -- 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. >> Stay informed about: Read data from SQL Server 2008 (Windows) to Informix in Unix

Habichtsberg, Reinhard

External

Since: Feb 23, 2006
Posts: 9

(Msg. 6) Posted: Fri Jul 02, 2010 2:25 am Post subject: RE: Read data from SQL Server 2008 (Windows) to Informix in Unix [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

OTC wrote > > 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. ) Good point. But can you configure readonly DSN's? You can do is with DataDirect Sequelink. What about security, encryption etc. with IBM Informix's driver? Reinhard. >> Stay informed about: Read data from SQL Server 2008 (Windows) to Informix in Unix

Superboer

External

Since: May 11, 2007
Posts: 18

(Msg. 7) Posted: Mon Jul 05, 2010 3:22 am Post subject: Re: Read data from SQL Server 2008 (Windows) to Informix in Unix [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

i would look at jdbc. have used this on windhoze for informix and mickey, to be honest have not used it from li/unix to mssql. it would really suprise me if it does not work. and yes it does require a bit of coding. Superboer. On 2 jul, 07:33, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > OTC wrote > > > > > 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. ) > > Good point. But can you configure readonly DSN's? You can do is with > DataDirect Sequelink. What about security, encryption etc. with IBM > Informix's driver? > > Reinhard. >> Stay informed about: Read data from SQL Server 2008 (Windows) to Informix in Unix

Display posts from previous:

Related Topics:

How to pass in arguments from unix script to INFORMIX 4GL .. - Let me explain the background of my problem before I post any question: I have a few programs as below: Program id: onkey.4gh -------------------------------- ..... ..... on key (F8) let g_onkey = 8 ..... Program id: hotkeys.h..

Windows 2 Unix Level 0 Restore - Currently we have our application running on a Windows 2000 Server using Informix 9.3. We have around 12 Disks and the dbspaces are distributed across these disks. The Dbspace path are as follows :- 42b68918 1 1 0 128000 73422 ..

How do I read a file with Informix 4GL? - What is the best way to read a flat file using Informix 4GL? Thanks

informix odbc for windows - Thank informix odbc for windows

Informix dbimport blob data slow - Hi people !!! I have the following situation : Informix 9.40.UC6 with Big Chunks Enable Linux Red Hat 8 - kernel 2.4 1 - I done the dbexport with -ss and the time was 1 hour and 40 minutes. This database that I exported has four blobspaces with 2k, 6k...

	Database Forums (Home) -> Informix	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum