Post reply

Transferring data from MySql to MS SQL Server

  • May 19, 2010 at 6:39 am

    #1169377

    You can create a linked server and then query it into your MS SQL DB. Do a little search on this forum about linking MySQL to MS SQL 😉

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • May 19, 2010 at 8:23 am

    #1169462

    Not directly relevant, but when converting MySQL to SQLServer, I used SQL_Maestro as an interface to dump out the tables for import into SQL .... FWIW

  • May 19, 2010 at 3:07 pm

    #1169775

    nikhil.desai1 (5/19/2010)

    Hi,

    This transfer should be online.

    What do you mean by the above?

    You could just export the data to a file and then import it.

    I've recently had to do this for a system that was delveloped in MySQL, granted there were a number of tables, but in the end I just did a MySQL backup which I could restore on the MS SQL 2005 server, then did a: INSERT INTO.... Select * from ....

    Linked servers are considered poor security.

    Leo

    Striving to provide a better service.

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

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

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