I see several options. Import/Export is one option, so is Bulk Copy. I use a Red-Gate tool SQL Data Compare which may be a bit more than what you are looking to do, but will do the trick as well.
Good luck.
Kurt
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman