SQL Server Performance

Copy Data

Discussion in 'SQL Server 2008 General DBA Questions' started by Seikha, Oct 3, 2009.

  1. Seikha New Member

    Hi ,
    I have to select a huge amount of data from a big table to another server in another domain. There is no excel in the server. Can any body please,suggest the best possible way to do that.
    Thanks in advance for your help
  2. FrankKalis Moderator

    Use either BCP or SSIS to copy the data to a flat table, copy the file over the network and load it on the other server.
  3. Adriaan New Member

    You don't need the Excel software just to use the Excel file format.
    SQL Server will gladly create an XLS file for a data dump, or read data from an existing XLS file.
  4. Seikha New Member

    Thanks for your suggestions.

Share This Page