Matt Carroll pleaded:
 
>Can anyone recommend the best mix of products, (if any) to replicate
>data from a SYBASE database to an Image/SQL database under MPE
>5.0.      I assume SYBASE's replication server is part of the mix on the
> [snip]
>Possible components in the configuration include replicating via/through
>an ALLBASE/SQL database attached to the IMAGE/SQL database.  An
>ODBC gateway or other process would be required on the HP3000 for
>SYBASE's replication server to communicate with the ALLBASE
>database.   Any thoughts or information would be greatly appreciated.
>
 
It is possible to copy data from/to Sybase to/from Allbase using
Powersoft's PowerBuilder using the Data Pipeline feature.  I don't
recommend this as a final solution, since it ties up your PC while the
reformat/copy is is progress.  Additionally, creating pipelines from
Allbase will usually result in PB GPFing on you; this has been my
experience.
 
Unfortunately, there isn't much else available, unless you want to
dump the Sybase table(s) to flat files using bcopy, transport them to
the 3000, and use ISQL's LOAD FROM EXTERNAL command to populate the
table.  This is not a pretty solution.  There just isn't much else that
I'm aware of.  I hear that EDA/SQL from Information Builders is capable
of miraculous things; you might check them out.
 
--Jim