Post reply

Recommended software to pole a MS SQL database and write to a MY SQL database

  • December 4, 2008 at 3:07 pm

    #96734

    I need to pole my MS SQL database about every 10 minutes and have the new data write to a MySQL database at another location.

    It is my understanding that I cannot do this directly from MS SQL, but need a 3rd party tool that can convert the MS SQL data to the MySQL data.

    Does anyone have a product they would recommend?

  • December 4, 2008 at 3:13 pm

    #907969

    You should be able to do this via sql ssis package, search this site, some one posted how to set up the odbc connection to do this, use google and you will find articles on doing the ssis piece.

    Andrew

  • December 4, 2008 at 6:23 pm

    #908033

    Download the ODBC client from http://dev.mysql.com/downloads/[/url] and use a DTS datapump to move the data (if you're on SQL Server 2000)


    Shamless self promotion - read my blog http://sirsql.net

Viewing 3 posts - 1 through 2 (of 2 total)

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