title: BCP from One Table to Another table in different servers in SQL Server 2008 R2
body: <p>I have two different servers. I need to transfer the data from One <strong>Server table</strong> to another <strong>server table</strong> (both are on same structure) using either <code>BCP</code> or using <code>BULK INSERT</code>. I need to do this on the run time. Can anybody please help me on this? I have a <code>linked share</code> connection established between the servers. Looking for an option to <strong>copy data</strong> faster.</p>