title: INSERT INTO from two different server database
body: <p>I am trying to copy the data of <code>testdabse.invoice</code> table to <code>basecampdev.invoice</code> table.
  <code>testdabse</code> is a local database while <code>basecampdev</code> is in the server.  </p>
  
  <p>My query for copying data to another table doesn't work, it says </p>
  
  <pre><code>Invalid object name 'basecampdev.dbo.invoice'.  
  </code></pre>
  
  <p>I've been reading this <a href="http://msdn.microsoft.com/en-us/library/ms190312.aspx" rel="noreferrer">documentation</a> but find it hard to follow and understand.  </p>
  
  <p>These are the information given from the server</p>
  
  <pre><code>Server type: Database Engine
  Server name: server.database.windows.net (this is not the real name)
  Authentication: SQL Server Authentication
  Login: myusername
  Password: mypassword  
  </code></pre>
  
  <p>How can I connect to the server so that I would be able to run this query</p>
  
  <pre><code>INSERT INTO [basecampdev].[dbo].[invoice]
             ([InvoiceNumber]
             ,[TotalAmount]
             ,[IsActive]
             ,[CreatedBy]
             ,[UpdatedBy]
             ,[CreatedDate]
             ,[UpdatedDate]
             ,[Remarks])
  SELECT [InvoiceNumber]
             ,[TotalAmount]
             ,[IsActive]
             ,[CreatedBy]
             ,[UpdatedBy]
             ,[CreatedDate]
             ,[UpdatedDate]
             ,[Remarks] FROM [testdabse].[dbo].[invoice]
  </code></pre>
  
  <p>Screen shot  </p>
  
  <p><img src="https://i.stack.imgur.com/rC97H.png" alt="enter image description here"></p>