A product I evaluated recently can do this pretty easily if your looking for something outside of the native SQL server tools.

http://www.jumpmind.com/products/symmetricds/download

It can move data between numerous types of RDBMS so may be overkill for your needs but it could fit.

Without much more information though its also possible with replication and ETL with SSIS, all depends on how much data your moving and how frequently.