Post reply

Import a data from mysql to mssql

  • April 8, 2014 at 9:43 am

    #306074

    Hi,

    I have a table in mysql which has 215 millions of rows and I want to migrate those 215 millions of rows to MSSQL table. Can this is be done thru BULK INSERT? If yes, how can that be done!

    Thanks,

  • April 8, 2014 at 9:57 am

    #1704191

    Bulk insert is used to import data from a flat file (txt, csv or anything with that structure).

    If you generate the file, you could use it.

    You could as well use SSIS or Import/Export Wizard (which is SSIS but on a wizard).

    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

  • April 8, 2014 at 11:05 am

    #1704215

    I will try that! Thanks,!

  • April 8, 2014 at 11:53 am

    #1704242

    You should look into linked server, check this out

    😎

  • April 8, 2014 at 12:12 pm

    #1704251

    Eirikur Eiriksson (4/8/2014)

    You should look into linked server, check this out

    😎

    It could help in other cases, but I'm not sure that it's the best option if you're trying to copy all those rows. I'd prefer a process that can work in batches.

    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

  • April 8, 2014 at 12:18 pm

    #1704257

    Luis Cazares (4/8/2014)

    Eirikur Eiriksson (4/8/2014)

    You should look into linked server, check this out

    😎

    It could help in other cases, but I'm not sure that it's the best option if you're trying to copy all those rows. I'd prefer a process that can work in batches.

    Good point, you are absolutely right, thanks for pointing this out.

    😎

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

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