title: Cross-server SQL
body: <p>I want to port data from one server's database to another server's database.
  The databases are both on a different mssql 2005 server.
  Replication is probably not an option since the destination database is generated from scratch on a [time interval] basis.</p>
  
  <p>Preferebly I would do something like</p>
  
  <pre><code>insert *
  from db1/table1
  into db2/table2
  where rule1 = true
  </code></pre>
  
  <p>It's obvious that connection credentials would go in somehwere in this script.</p>