Sybase and SQL Server

[dj4uk]

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

[Merrion]

It is possible - Sybase XI and ASE can do replication to a range of target DBs..we have a Sybase-DB2 rep thang going on here.

To set the tables in Sybase to replicate use the sp_setreptable stored proc.

[dj4uk]

Is there any way of taking the structure of the Sybase database and creating it within the SQL Server database. Basically an initial import.

DJ

[Merrion]

Yup - they use the same T-SQL syntax to create tables (pretty much - I think SQL server has some extra options in indexes and constraints)

Export your db schema (with whatever db tool you use on sybase) to .sql files then run them in to SQL Server.

[dj4uk]

I've tried exporting the database schema and then running the sql files within SQL Server but there do seem to be differences in syntax between the two as I get errors.

DJ