• Transnational Replication might do the job but if the primary database is going to be updated with new tables and columns then this could become a problem since it would not sync unless you add as an article and also it will add identity columns to all of these so i feel that you can use mirroring and snapshot it on the reporting server and this way you can snapshot whenever you need the latest.