Have a look into
SQL Server Replication[
^]
MSDN Article - Data Replication[
^]
If you have full access to the SQL machines, replication is exactly what you want :)
If you cannot use replication then you could certainly achieve this using SSIS. You could write a simple package to retrieve all information from the 'Source' server and then update the information on the 'Target' server
Depending on how much information we are talking about, there may be constraints around this. For example, if you have many millions of rows, you'd only want to update existing rows with changes and insert any new rows.
If you've only got thousands, I'd probably just clear down the Target server and repopulate from Source. Again though, it depends on your constraints, data availability requirements etc
Submit an article or tip