Like Gail stated. The easiest way is to backup the db and restore it into the new SQL Server. Then just drop the tables you don't need.