1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Transfering between two sql servers

Discussion in 'C#' started by ja0, Oct 4, 2010.

  1. ja0

    ja0 New Member

    Joined:
    Oct 4, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I want to know how to transfer between two server a data table without using the SPROC for link them.
     
  2. techgeek.in

    techgeek.in New Member

    Joined:
    Dec 20, 2009
    Messages:
    572
    Likes Received:
    17
    Trophy Points:
    0
    Occupation:
    EOC (exploitation of computers)..i m a Terminator.
    Location:
    Not an alien!! for sure
    Home Page:
    Microsoft SQL Server includes a popular command-prompt utility named bcp for moving data from one table to another, whether on a single server or between servers. The SqlBulkCopy class lets you write managed code solutions that provide similar functionality. There are other ways to load data into a SQL Server table (INSERT statements, for example), but SqlBulkCopy offers a significant performance advantage over them.
    http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx
     

Share This Page