CJW99


Hello everyone,

We are desperately wanting to perform transactional replication from a Sybase 12.5 Databse to an SQL server 2000 database. Unfortuneately we cannot migrate the entire Sybase system to SQL server!! Bascially we want to replicate a small subset of the tables from the Sybase database to a SQL server where we can manipulate this isolated data...

Any suggestuions on wether this is possible, and what new software products we may need, will be greatly appreciated.

Thank you

Chris





Re: Replication Question

Jeffrey D. Baker - MSFT


Moving this thread to the Replication Forum. Hopefully they can answer your question.

-Jeffrey







Re: Replication Question

Yunjing MA

SQL Server 2000 doesn't support hetero as publisher yet. SQL Server 2005 support Hetero DB server as publisher and/or subscriber, but so far it only supports Oracle and DB2.

Thanks

Yunjing







Re: Replication Question

MaheshKshirsagar

Hi,

I have SQL Server 2005 Evaluation Edition for a POC for a client. ISQL2K5 Eval.Ed. doesn't support replication with Sybase. Do you have any idea how to set this up I am recommneding SQL Server 2005 as a choice for their database for go live. They might not consider it if It will not support Sybase replication as their other functional systems are using Sybase as backend.

Any thoughts

Thanks,

Mahesh.





Re: Replication Question

Hilary Cotter

there is a code sample which shows you how to write your own distributor interface for any provider. It is the samppub one in the code samples directory. You can find it in c:\Program Files\microsoft SqL Server\80\Tools\DevTools\Samples\SQLRepl\Samppub.

If you don't want to write your own interface you can use a product like Data Mirror.

You may also be able to use DTS to pull data locally into a staging table and then load it to your production tables.






Re: Replication Question

Hilary Cotter

You will have to write something yourself or use SSIS for this.