title: Copying SQL Server Data to another Database on another Server
body: <p>I have installed a SQL Server database on my customer's server.</p>
  
  <p>I have an exact duplicate database schema on my laptop to enable me to work on things whilst I am off site.</p>
  
  <p>However I need to copy the actual data in the customers database into my copy on the laptop, in order to test a few things.</p>
  
  <p>What is the easiest way of doing this?</p>
  
  <p>The customer server and my laptop are not connected (although I have VPN access to the customer's server) so I do not believe I can do this with TSQL.</p>
  
  <p>Is there a way to Export from SSMS and then Import into my laptop database?</p>