# MSSQL & PostgreSQL

## DBConvert
- data migration from source db to destination db
- either Dump or PHP script at destination stage
- **not our requirements**

## DBSync
### Sync directions:
- cross-database synchronization

MySQL, MariaDB ↔ PostgreSQL
MySQL ↔ MariaDB ↔ Percona
MySQL ↔ Amazon RDS | Aurora ↔ PostgreSQL
MySQL ↔ Heroku Postgres ↔ PostgreSQL
MySQL ↔ Google Cloud ↔ PostgreSQL
MySQL ↔ Azure Database for MySQL ↔ PostgreSQL
MySQL ↔ CockroachDB ↔ PostgreSQL

- require **direct access** to **both** source and destination db
- sync option: insert, update, drop
- Bi-direstional Synchronization [not required]
- Trigger-Based synchronization [no permission]
- required to create triggers and shadow tables on **both** db
- https://dbconvert.com/blog/trigger-based-database-synchronization/
- Built-In Scheduler
- daily, weekly, monthly etc sync
- https://support.dbconvert.com/hc/en-us/articles/201214762-Using-built-in-scheduler-for-DBConvert-products
-