you can use SSIS to migrate your data from 1 db to another. You can create a DB with that tables you need, then create an SSIS package and point to the databases and tables you need and map those to your new database.

I have several SSIS packages that do something similiar. Go from oracle, access, etc. and I import the data into 1 SQL database