• I think you can consider Replication/CDC/CT. BTW, if SQL 2012 is not enterprise edition, forget about CDC.

    GASQL.com - Focus on Database and Cloud