Sharing the data between Sybase & MSSQL7
Hi
May be this is not the greatest question
to start Sybase club but...
I have Sybase servers and MSSQL7 server and
databases need to share data on hourly basis both ways.
I would appreciate your advice on what is the
most reliable way to share data between Sybase and MSSQL7?
I can use DTS to transfer data from Sybase to MSSQL7.
Since MSSQL7 uses 8Kpages I'm not sure that I will be able to
use DTS to put the data back from MSSQL7 to Sybase.
Is the BCP the only way to do this?
Thanks
Andrew
Sharing the data between Sybase & MSSQL7 (reply)
My understanding is that you can use it to go both ways (DTS) - you can also replicate between them (I believe) since you can use OLEDB and ODBC driver combinations to get between them.
If you've tried the DTS to Sybase without success, I could be wrong, but... This was one of the big design goals of SQL 7 and DTS specifically - interoperability between the major db players.
SW
On 1/8/99 8:48:37 AM, Andrew S. wrote:
> Hi
May be this is not the greatest question
to start Sybase club but...
>
I have Sybase servers and MSSQL7 server and
databases need to share data
> on hourly basis both ways.
I would appreciate your advice on what is
> the
most reliable way to share data between Sybase and MSSQL7?
I can use
> DTS to transfer data from Sybase to MSSQL7.
Since MSSQL7 uses 8Kpages
> I'm not sure that I will be able to
use DTS to put the data back from
> MSSQL7 to Sybase.
Is the BCP the only way to do this?
> Thanks
Andrew
Sharing the data between Sybase & MSSQL7 (reply)
You could set the Sybase up as a linked server (oledb on top of odbc) and share data that way.
------------
Stephen Wynkoop at 1/9/99 5:01:31 PM
My understanding is that you can use it to go both ways (DTS) - you can also replicate between them (I believe) since you can use OLEDB and ODBC driver combinations to get between them.
If you've tried the DTS to Sybase without success, I could be wrong, but... This was one of the big design goals of SQL 7 and DTS specifically - interoperability between the major db players.
SW
On 1/8/99 8:48:37 AM, Andrew S. wrote:
> Hi
May be this is not the greatest question
to start Sybase club but...
>
I have Sybase servers and MSSQL7 server and
databases need to share data
> on hourly basis both ways.
I would appreciate your advice on what is
> the
most reliable way to share data between Sybase and MSSQL7?
I can use
> DTS to transfer data from Sybase to MSSQL7.
Since MSSQL7 uses 8Kpages
> I'm not sure that I will be able to
use DTS to put the data back from
> MSSQL7 to Sybase.
Is the BCP the only way to do this?
> Thanks
Andrew