• I would generate the script with all the drops via the "generate scripts" task. Create the database on 2008R2 run the script in. Then generate the SSIS package via export data wizard with the right mappings. Then modify the SSIS package it calls to include the script to drop and recreate the tables.

    The majority of the tasks will be done so will just be a case of maintaining the script and the SSIS package for new tables, columns, procs etc and running it via a SQL job.