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?