How can Replicate Between Ms SQL 2005 to MYSQL

• engin

  SSC Rookie

  Points: 35

  More actions

  September 14, 2006 at 4:38 am

  #192108

  Hi;

  I have sql 2005 server in my local area and mysql server on internet..

  How can replicate Ms SQL 2005 to MYSQL ? is that possible ? or any possible version this server ?

  I try sql 2000 server for replication; publishing starting but then i take "invalid cursor state " message. i delete tables msrep7 in mysql then  replication starts but if replication stop for any reason , i must delete table again again...

  is this bug in sql 2000 ? how can fix that ?

  Thanks...

• September 18, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Ronzo

  Hall of Fame

  Points: 3917

  More actions

  September 20, 2006 at 9:16 am

  #661534

  The problem you are describing with SQL 2000 replication sounds like the one that was fixed in Service Pack 4.

  ---

  Have Fun!
  Ronzo