I wanted to share some questions I came across during a migration from Sybase ASE to SQL Server 2008.
Is it possible to do a transactional replication from SQL Server to Sybase?
- Yes, it is. You can replicate via the Sybase OLE DB driver, if you set it up as a linked Server. You can only setup this replication using the SQL Server system SPs for replication.
Is it supported?
- Hmm, it is not explicitly not supported :-). Transactional replication is supported for so called non-SQL Subscribers, but all the examples are only for Oracle as replication target.
Which replication will work?
- Transactional, thats it. And only push is possible.
What if I want to replicate from Sybase ASE to SQL?
- You can use the Sybase Replication Server, but this is not for free. It costs per processor core of the replication machine. Hint: use a virtual machine as replication server and give it one processor. Saves you money
Can I replicate via stored procedures as in SQL Server?
- YES. You can create SPs in Sybase for Update, Insert and Delete and configure those to be called when the data comes in.
Thats it. If you want to know more about, give me a mail. It is too much to write down here.