Post reply

transfer data from mySQL running on Unix

  • October 5, 2006 at 2:08 pm

    #75070

    whats the best way to accomplish this task i.e. transfer data from mySQL running on unix to SQL Server?

    thanks

  • October 6, 2006 at 12:49 am

    #664512

    You can create a dsn for mySql server, then use DTS for transfer the data through that.

     

    ------------
    Prakash Sawant

    http://psawant.blogspot.com

  • October 6, 2006 at 7:37 am

    #664592

    DTS package, just be carefull with your data type transformations. Sometimes the wizard stuff gets a little buggy, just go through all of your columns to verify the mySQL data type and the SQLServer datatype are the closest match.

    Good Luck

  • October 6, 2006 at 8:18 am

    #664610

    thanks for you replies.

    I am looking at the options that I have to create DSN. however I dont see anything in there for mySQL. which driver do you think I need to pick from the list?

     

    thanks

  • October 6, 2006 at 2:49 pm

    #664680

    For ODBC, you'll have to get a driver.  Google is your friend on that.

    Now, if your data transfer is a one-time thing, you might be able to use the "alternative scripted backup method" available in MySQL, which generates table create and insert statements from your current data.

    I don't know much about the details, or what it is really called.  I'm only pretty sure that such a type of backup option is available in some recent version of MySQL. 

     

    Since you mentioned that you are looking for the "best" way, I know that you mean that you will turn off the MySQL database and never use it again.  Therefore, my way is the best way. 

    jg

     

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

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