Results 1 to 4 of 4

Thread: auto get data from MS SQL server n insert into mysql database? Urgent

  1. #1
    Join Date
    Aug 2006
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default auto get data from MS SQL server n insert into mysql database? Urgent

    the problem now for me is i need get data from MS SQL server everyday for daily data and insert into mysql database.

    Isnt possible to create a script to auto this process?? how can it do it?
    impossible to done it manually rite? everyday must be done it....

    pls help me.....

    thanks

  2. #2
    Join Date
    Sep 2005
    Location
    India
    Posts
    1,625
    Thanks
    6
    Thanked 107 Times in 107 Posts

    Thumbs up

    Yes it can be done via a script, you just need to load the script it will read the data from your MS SQLServer database and insert into a table which is in MySQL that can be used for your day to day operations.

    But you haven't mentioned your scripting language preference ASP, PHP, ColdFusion, Java, etc. Without that information i think it is very difficult to comment about that.

  3. #3
    Join Date
    Apr 2006
    Posts
    190
    Thanks
    3
    Thanked 7 Times in 7 Posts

    Default

    MySQL has some GUI Tools and one of them is a MySQL Migration Toolkit 1.1 that well allow you to migrate your MS SQL database or other database to MySQL.
    Ryan
    Sevierville, TN

  4. #4
    Join Date
    May 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default info path,

    hi CStan,

    i have read you post. I am facing the same problem. I want to get data from SQL Server and store it in variables, I am using vbscript. If you have done with this plz help me.

    Waiting,
    Regards,

Bookmarks

Posting Permissions

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