> For the complete documentation index, see [llms.txt](https://docs.arkannis.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.arkannis.net/database/general-sql/sql-replication-best-practice.md).

# SQL Replication - Best practice

Usual procedure for replication from PRODUCTION to QUALITY/TESTING:

1. Backup User rights from DB QS
2. Full Backup of DB PROD
3. Full Backup of DB QS
4. Overwrite QS DB with data from PROD DB
5. Overwrite User rights on QS DB with previous rights