Post reply

How can we move the data from one table to another table in diff server

  • September 18, 2014 at 4:52 am

    #310953

    How can we move the data from one table to another table in diff server

    server 1 have 5 million records and it need to move to server 2 table in another server instance

    Thanks

    Naga.RohitKumar

    Thanks
    Naga.Rohitkumar

  • September 18, 2014 at 5:53 am

    #1746351

    naga.rohitkumar (9/18/2014)

    How can we move the data from one table to another table in diff server

    server 1 have 5 million records and it need to move to server 2 table in another server instance

    Thanks

    Naga.RohitKumar

    Quick thought, use the import export wizard in SSMS.

    😎

  • September 18, 2014 at 9:20 am

    #1746452

    BCP out and in is the quickest option in my opinion.

    Use the native format (less pain involved).

    -- Gianluca Sartori

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

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