title: SQL Server 2005 - Export table programmatically (run a .sql file to rebuild it)
body: <p>I have a database with a table Customers that have some data<br><br>
  I have another database in the office that everything is the same, but my table Customers is empty<br><br>
  How can I create a sql file in SQL Server 2005 (T-SQL) that takes everything on the table Customers from the first database, creates a, let's say, buildcustomers.sql, I zip that file, copy it across the network, execute it in my SQL Server and voila! my table Customers is full<br>
  <br>
  How can I do the same for a whole database?</p>