Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006
    Posts
    115

    Unanswered: replicate sybase data to other sql db like sql server

    i need to replicate sybase data changes to other sql db like sql server periodically. Other than sybase replication server, does any method can do that? e.g can transaction log content extract out as DML statement, like insert, delete, update so that i can apply the same DML statement against other sql db?

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Distributed transaction to MSSQL Server using Direct Connect. This is very messy, replication server is clean and mangeable for large scale transactions.

  3. #3
    Join Date
    Jul 2006
    Posts
    115
    yes, replication server provided by sybase is very good ... but it's expensive too.... any alternative?

  4. #4
    Join Date
    Aug 2006
    Posts
    4
    Expensive in terms of implementation ?, It is the best solution and best product of its class. Regarding alternatives - please don't try to re-invent the wheel.

  5. #5
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    And end up with an octagon, for ten times the price of RepServer ... and then blame Sybase ...
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •