• You can use Replication.

    http://www.sqlservercentral.com/stairway/72401/