Is it possible to Connecting MYsql with sql server ?

• maida_rh

  SSC Eights!

  Points: 974

  More actions

  October 18, 2012 at 1:23 am

  #265796

  I am using an open source software which support mysql and i create application that uses asp.net 4.0 and sql server 2008....

  Is it possible to Connecting MYsql with sql server ?

  I want every insertion and updating should be made to both database servers as they have same schema of tables but one is mysql and other is sql server 2008 ?

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  October 18, 2012 at 2:00 am

  #1550326

  Hi,

  Yes it is. Check this article: http://www.sqlservercentral.com/articles/MySQL/88366/

  Regards

  IgorMi

  Igor Micev,My blog: www.igormicev.com

• maida_rh

  SSC Eights!

  Points: 974

  More actions

  October 18, 2012 at 3:04 am

  #1550338

  I checked your link and trying the solution provided....

  but need to know as it has any limitation or dis advantages on database transactions etc

  Thanks alot 🙂

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  October 18, 2012 at 3:07 am

  #1550340

  Oh, I needed it once and used it. It was working fine, but i didn't keep on digging about the dis/advantages...

  If you find out something please share it...

  Thanks

  IgorMi

  Igor Micev,My blog: www.igormicev.com

• maida_rh

  SSC Eights!

  Points: 974

  More actions

  October 18, 2012 at 3:20 am

  #1550347

  Oh! but thanks and I will sure do that ....but i am quite a newbie to linked server etc:-)