You can use RDMBS replication technology - Oracle Golden Gate, Oracle Data Guard, SQL Server Always On, PostreSQL Slony, then you can keep the dev in sync with prod, but do you really want that? you could simply restore a database backup of prod into dev every week or so, your database administrator can help choose the best solution and even automate the process.
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov