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 (AT) yahoo (DOT) es> 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:

On 30 jun, 23:10, D <kingslacker... (AT) gmail (DOT) com> wrote:
What products ODBC for HP-UX do you recommend ?
I know the DataDirect, is there another option ?

OTC wrote
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.

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:

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/d...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

__________________________________________________ _______________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail.
http://www.windowslive.com/campaign/...M_HMP:042010_5