I have a client who has an inhouse system running on a Sybase database. We are going to develop a new website for them that will be running off a SQL Server database.

The client does not want the website running straight off their internal database hence the SQL Server one but it is anticipated that there will be syncronisation of the two at certain times of the day (possibly only once a day).

Has any one here had any experience of connecting (possibly replicating) SQL Server and Sybase databases?

Any advice regarding this would be greatly appreciated.

DJ