title: Import data from SQL database on server to SQL database on localhost
body: <p>We have a database with a very large amount of data in it (around 400k records per table). I'd like to be able to debug a stored procedure on this database, however I do not have the permissions to do that on the server it's on. </p>
  
  <p>As such, I need to create a replica of the database on localhost and debug from there. </p>
  
  <p>However.. due to the large size the script that gets created is too large for SQL Server Management Studio to open. </p>
  
  <p>Is there a way to directly import the data from one database to another if one is located on localhost and the other is not? The security issues shouldn't be a problem for importing/exporting data, I'm told. </p>