erics44 (9/5/2012)
What are the issues with using replication to move data between a live database and one used for reporting?is this the best way to get real time data into a reporting database?
There is no "best way". It depends on your situation.
For near real time you will need to use transactional replication and control access to prevent reporting data modification.