Moving tables to another SQL2008 database (including indexes, triggers, etc.)
Scripting out the tables, then using SSIS to transfer the data would be the most reliable and effective way of moving the data to the new database.