Copying data

Question

I would like to know how to copy data from the user acceptance test database server to my unit test database server. Both tables have the same format. I just need to obtain  data to test with. The only  way I can see to accomplish this task is to use the import wizard on the sql server 2008 r2 database.