question

jayeshanandani avatar image
jayeshanandani asked

Link mssql to mysql.

I have a mysql database on my local computer. I am creating a website in php using mysql database. Now my website has some dependencies with respect to datadase. I need to fetch certain tables of my database from a 3rd party website which is built is ASP.NET and uses Microsoft SQL Server 2005. I am a newbie to this type of connections. I need to establish connection in such a way that any updation done to tables of mssql database ( asp.net side) should also be done to my database (mysql) or my table should get updated every 1 hour and should be exactly same as table present at other side.
mysqlconnectionmssqlasp.netphp
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Venkataraman avatar image
Venkataraman answered
You need replication to achieve this. But, SQL Server does not support MySQL as a subscriber for replication. It only supports ORACLE and DB2. This post talks about a possible solution to your problem. http://stackoverflow.com/questions/5904447/replication-between-sql-server-and-mysql-server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.