I have a need for a real time replicated database of our SQL Server based ERP system. The source database is about 500 GB in size. The new database will be used for on the spot production data analysis and real-time reporting / dashboards.
There is no need to update the source database with changes made by subscribers, but the replicated db might change during testing. There are no filter requirements either.
Is replication the correct solution for this requirement? If so, what replication method should I use?
You can use Transactional Replication, but it won't be real-time. It'll be 1-2 seconds behind usually but could be several minutes to even several hours behind if a large transaction runs.