Move SQL Table From One Server to Another Server in Sql

    General discussion

  • Hi All,

    I would like to know what are all the possible ways to move a sql table from one server to another.



    Monday, November 08, 2010 3:40 AM

All replies

  • One way is, You can use the DTS import and export wizard to copy the data.

    Another way is, Create a linked server and directly write an insert statement to move the data from one table to another table

    Monday, November 08, 2010 3:50 AM
  • You can generate schema script with data and execute that srcript on another  server.

    Right Click Database, Goto Tasks --> Generate Scripts. Follow the wizard and select True for "Script Data" option in "Choose script options" Tab.


    Please visit my Blog for some easy and often used t-sql scripts
    Monday, November 08, 2010 5:57 AM
  • Hi SSDL,

    And a fourth way is to use the command line utility bcp.exe to create
    a flat file with the contents of the table, then use either the same
    utility or BULK INSERT to read that file in a table on the destination
    server. (You must first make the table - you can use SSMS to script
    the CREATE TABLE statement).

    Hugo Kornelis, SQL Server MVP
    My SQL Server blog:
    Monday, November 08, 2010 8:21 AM