-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|