Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is it possible to Connecting MYsql with sql server ? Expand / Collapse
Author
Message
Posted Thursday, October 18, 2012 1:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:39 AM
Points: 46, Visits: 111
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 ?

Post #1374171
Posted Thursday, October 18, 2012 2:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 2,901, Visits: 2,925
Hi,
Yes it is. Check this article: http://www.sqlservercentral.com/articles/MySQL/88366/

Regards
IgorMi




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1374185
Posted Thursday, October 18, 2012 3:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:39 AM
Points: 46, Visits: 111
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 :)
Post #1374202
Posted Thursday, October 18, 2012 3:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 2,901, Visits: 2,925
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,
SQL Server developer at Seavus
www.seavus.com
Post #1374204
Posted Thursday, October 18, 2012 3:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 7:39 AM
Points: 46, Visits: 111
Oh! but thanks and I will sure do that ....but i am quite a newbie to linked server etc
Post #1374211
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse