I was thinking of transactional replication as well. I was going to do snapshot replication as a temporary fix and then implement transactional later. Mirroring plus snapshots is a good idea but we only have SQL 2008 Standard so we can't create snapshots. Thanks for the input!