• Have you considered Transactional Replication? If you know the tables you need to report from, you can just choose those tables to be involved in the replication.Any changes to the tables would be immediately copied across (allowing for any network latency). Users wouldn't be disconnected either.