title: copy data from one server to another using query in import/export wizard?
body: <p>I have one table a in one db server..and table b in another server.</p>
  
  <p>I would like to update the table b using values in table a.</p>
  
  <p>How do I specify the server name in query ?</p>
  
  <pre><code>UPDATE SELECT * from [db1].[dbo].StgMGBPData
     SET ASO_Ind = [db2].[dbo].Customer_Names.ASO_Ind,
         Company = [db2].[dbo].Customer_Names.Company,
         Rpt_Cust_ID = [db2].[dbo].Customer_Names.Rpt_Cust_ID
    FROM [db2].[dbo].Customer_Names
    JOIN [db1].[dbo].StgMGBPData ON [db2].[dbo].Customer_Names.Src_Cust_ID = [db1].[dbo].StgMGBPData.CustomerID
  </code></pre>