次の方法で共有

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

  • Anonymous
    June 08, 2011
    The comment has been removed

  • Anonymous
    June 09, 2011
    I am interested to know more about this, I'm not sure how to mail you however. Thanks, Patrick

  • Anonymous
    June 10, 2011
    Patrick, sorry, forgot to enable the EMail Author Link. It is now there.

  • Anonymous
    August 01, 2011
    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).

  • Anonymous
    February 13, 2012
    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

  • Anonymous
    January 17, 2016
    I am wondering is it possible to replicate (transactional) data from Sql Server 2012 to Sybase 1.5 or later.