Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    13

    Unanswered: Copy data (table) from MS Sql to MySQL

    How can I copy a table from MS SQL to MySQL?

    Thanks,

    Amit

  2. #2
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: Copy data (table) from MS Sql to MySQL

    Create a DTS task using SQL Server as the source and MySQL (via MyODBC) as the target.

  3. #3
    Join Date
    Nov 2003
    Posts
    8

    Re: Copy data (table) from MS Sql to MySQL

    Thanks for the reply.

    Is there any way where I can add the MySQL Server as a Linked server to MS SQL server and then update or change rows in MySQL as per the update in MS SQL server?

    Thanks,
    Amit

  4. #4
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: Copy data (table) from MS Sql to MySQL

    Users in the SQL Server forum will probably be able to tell you better how to do this. All I can tell you is to have MyODBC installed on the SQL Server box.

Posting Permissions

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