Markus (5/20/2014)
If you are pondering the replication route remember every single table HAS to have a primary key in order for it to be replicated.
You can use Snapshot replication for tables that do not have primary keys. Snapshot basically copies the entire table and replaces it at the target, so I used it for smaller, more static tables.