Replication SQL Server to Sybase


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.

Comments (6)

  1. felix says:

    Its really awesome esp. for USA,UK and German friends

    http://adf.ly/1kFUB

  2. Patrick says:

    I am interested to know more about this, I'm not sure how to mail you however.

    Thanks,

    Patrick

  3. Patrick, sorry, forgot to enable the EMail Author Link. It is now there.

  4. Marc says:

    Please not that even if you use a VM, Sybase now requires that you licence the replication server per core on the host. If you have a 2 CPU quad core for you VM host, you will need to licence the Rep Server and the SQL agent for  8 CPU/core (2X4).

  5. Jeff says:

    Sorry to be late to the party.  We tried with the VM but Sybase Replication server heterogeneous option crashed our VM.  We were forced to move to a stand alone and throttle(disabled) 6 cores via the OS, we only bought a 2 core license.  When the SW starts up it checks the core count and then checks out its licenses from sysam.

    Jeff

  6. Vp says:

    I am wondering is it possible to replicate (transactional) data from Sql Server 2012 to Sybase 1.5 or later.