Difference between Transactional and Reporting Database
This is a transactional database: A transactional database is a DBMS where write operations on the database are able to be rolled back if they are not completed properly.
If a transactional database system loses electrical power half-way through a transaction, the partially completed transaction will be rolled back and the database will be restored to the state it was in before the transaction started.
This is a reporting database: A database used by reporting applications. Reporting databases are often duplicates of transaction databases used to off-load report processing from transaction databases.