Post reply

exporting data

  • June 10, 2014 at 7:28 am

    #289785

    Hi guys,

    I need to export millions of data from a database going to another server/database.

    I read bcp can do this faster than import export wizard.

    Do I need to export it to a data file first then importing it to a table or database using bcp?

    Or is there a tool/way to export it directly to a database aside from import export wizard?

    Thank you in advance for your help!

    Newbie here. 🙂

    Cheers!

  • June 10, 2014 at 8:35 am

    #1720434

    Hi welcome to the forums,

    bcp only allows to export to a text file (regardless of format or extension). If you want to use it, you'll need to have the intermediate step.

    Import/export wizard is a wizard to create an SSIS package which you can save and modify. If you open it, it might seem more complicated but it can be very powerful.

    Those are usually the best tools to transfer from one server to another.

    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

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

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