Post reply

Import data from MSSQL to MYSQL

  • July 10, 2015 at 10:22 am

    #305684

    Hi,

    I want to know can we write a script to transfer data from MSSQL to Mysql.

    I need to build a SQL job for this.

    SQL server I am using : 2008 R2

    Mysql : 5.1

    I have created linkserver for Mysql in sql server.

    Thanks in advance,

    Thanks

    Tulika

  • July 10, 2015 at 10:54 am

    #1811687

    Have you tried the import/export wizard to create an SSIS package and use that on your SQL job?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 10, 2015 at 11:29 am

    #1811706

    No I am just researching for possibilities..... thanks for your advice.

  • July 10, 2015 at 12:08 pm

    #1811717

    Is this a 1 time deal or will you need to continuously transfer data from SQL Server to MySQL?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 10, 2015 at 12:33 pm

    #1811729

    it will be a ongoing process

  • July 10, 2015 at 12:41 pm

    #1811735

    Then I would opt for the linked server option and custom code to keep the data pumping across to MySQL.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 10, 2015 at 12:56 pm

    #1811740

    Thanks Jason,

    I need help for this custom code, can you suggest where I should look?

  • July 10, 2015 at 1:05 pm

    #1811744

    tchaturvedi (7/10/2015)

    Thanks Jason,

    I need help for this custom code, can you suggest where I should look?

    The custom code will depend entirely on your environment and database. You would need to write it or hire somebody to write it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 10, 2015 at 1:16 pm

    #1811748

    Thanks

Viewing 9 posts - 1 through 9 (of 9 total)

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