title: SQL Server 2008: copying the contents of all tables from one database into another database
body: <p>I have two databases with THE SAME schema. I need to copy the contents of all the tables from one database into the other database. What is the best way to do this? There are about 200 tables. I have ssms.</p>