I have an SQL database on a host server and a copy on a local server.
The host server is registered on my local server.
Every day I run a DTS package copying the whole database (objects and data)
from the host to the local server.
I could limit the copy to objects only, data only or selected objects and/or
If you can register one server from the other one, you can do your copy
(even schedule it).
If you can't, the other answers you got will have to suffice.