Data Migration sql server 2008- 2012

There are two databases used by two different LOBs for same functionality. They have similar schema but not same.
Now the plan is to merge one into another and have single DB.

one db is in sql server 2008 and another is 2012 and we are bringing data from 2008 to 2012. right now we are checking each table in both databases manually for missing columns/mismatch of datatypes and datatype length. Is there any tool that can do this faster?

Also when we migrate it may not be straight migrate we might have to run business rules. what is the best approach to proceed?

thanks for your time.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

If you have to apply business rules, you would probably be better off writing your own custom script to migrate the data.  I would backup and restore these databases to a test server and start building the script table by table.  Then test vigorously.  Restore the original databases and test some more.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Use Integration Services (SSIS). It's the right tool for ETL. It allows you to analyze and transform data before importing. You can also add .NET code for more complex rules and validations.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.