Replication setup betweek sqlserver2k5 and mysql

  • Hi,

    This is my configuration.

    Sqlserver2005 on windows 2003 server

    MYsql5.0 on SUNSPARC10 machine.

    Is it possible to setup the replication between these two server.

    Is so, what are the steps involved for replication.

    If any of friends or gurus have this situation , please share your views.

    Thanks for your time.

  • You need to be more specific about the type of replication, the type of articles you intend to replicate, data types, etc.

    The short answer is yes, you can replicate from a SQL 2005 publisher to a MySQL subscriber using SQL Server replication, but depending on what you are actually trying to do, it may not handle your situation.

  • Michael, I appreciate for your reply.

    The replication is for reporting purpose on SQLServer machine.

    The main intention is replicating the reporting tables on sqlserver machine. As I am new to sql server, can you let me know where to start this task or provide the link if you have any.

    Thanks for your time.

    Have a good day.

  • Well then, I believe the answer is no.

    I do not believe you can use MS SQL replication services and make a MySQL database your publisher.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply