SQL Server Performance Forum – Threads Archive

Database Replication

I need to find the best way to replicate data between a Sybase DB and SQL Server 2000 in real-time or near real-time. I have a dedicated T1 line between the Sybase installation in Denver and the SQL Server installation in Dallas. I am willing to buy a third party tool if it doesn’t cost too much. ($30,000 max)

SQL Server supports replication with heterogeneous data sources, provided you have an ODBC driver or OLE DB provider for that data source. Two types of replication are available today for heterogeneous database replication: snapshot and transactional replication. With snapshot replication, the database sends a point-in-time snapshot of the database to or from SQL Server. Using SQL Server and an OLE DB provider or ODBC driver for Sybase, you can send and receive database snapshots in both directions, and send SQL Server transactions to Sybase. Refer tohttp://www.microsoft.com/sql/partners/ link for further information on third party tools solution. HTH Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>