title: How to Transfer data between different SQL Server?
body: <p>I want to Transfer data from One SQL Server to another SQL Server.</p>
  
  <p>Sql Server Credential</p>
  
  <pre><code> sql server name = Test
   UserName = sa
   Password = test1
  </code></pre>
  
  <p>Another Sql Server Credential</p>
  
  <pre><code> sql server name = Test1
   UserName = sa1
   Password = test12
  </code></pre>
  
  <p>Now i want to transfer data from Server Test to Server Test1, How can i do in store Procedure?</p>
  
  <p>Also i dont wanna use backup file i want to right only store procedure.</p>
  
  <p>Thanks in advance </p>
  
  <p>Regards
  Amit Vyas</p>