C# Console App for migrating data into new database

I have a database of about 30 tables I want to migrate into another database using new tables and structure. I need a console app that I can connect to both old and new databases and transfer the data rows over. I don't want to create models for the old database, hoping to use dynamic or generic and I will map it to my new classes myself. What I want is a simply implementation of this (OLD DB (dynamic) => NEW DB (entity model)). My new database uses EF6 Code-First.