• It is a fine idea and a frequently used solution. I would recommend that you use transactional replication. To begin you will need to figure out what tables are needed for reporting (assuming it is not all) and then do some reading on configuring replication. Shout back if you have questions.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot