I have come across the following scenario in a practice test:
- Data from DB1 is accessed periodically by an external application.
- Data from DB1 will be sent to another DB, DB2, as soon as changes occur to the data in DB1.
- All data in DB1 is recreated each day and does not change until the next data creation process.
To synchronize DB1 to DB2, should you use snapshot replication or transactional replication? Transactional replication seems fine, but isn't snapshot replication suitable as well and you do a snapshot everyday since DB1 data changes just once a day?