Copy data from one database to another?

Question

I am upgrading a clients app to a newer version, the databases are close but slightly different. I need to figure out a way to transform and copy the data from one table in one database to another table in the new database. Oh geez :(

Answer 1

INSERT INTO new_db.dbo.TableA
SELECT * FROM old_db.dbo.TableB

If the tables are the same, this is probably the easiest way.