title: Move selected data from one server to another sql server 2008
body: <p>I need to move selected data from 800+ tables in one database to the same 800+ tables in another database in another server. The data I select is based on date fields of every table. So, if I say table 1 date from 01/01/10 to 01/15/10, then only that data I want to be copied into the other server's database table specified.
  I hope I am not confusing anyone. What is easiest way to do this?</p>