Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    4

    Unanswered: Sync MS SQL 2005 to MySQL DB?

    OK, I am a long time computer enthusiast, but I am very new to Databases. I have a MS SQL 2005 database which I need to sync with a MySQL database (for a website). I am willing to buy off-the-shelf software, but I don't know where to start really.

    My needs are small. I just need it to copy several rows (about 7) from 1 table in my MS SQL DB to one table in the MySQL DB. From there I need it to change some variables using (basic) conditional logic. IE If stock count is less than 10, mark as "0". or If price is less than $10, add 10% + $1. It all seems like childs play really.

    I found DBConvert which would sync the information but would not convert the variables in any way. Can anyone suggest a better software? It doesn't need to do anything more than what I'm asking here and it doesn't need to be free.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you can live with something that is included with SQL 2005 and can do much more, create a SSIS package to do what you need.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •