---
# System prepended metadata

title: MSSQL & PostgreSQL

---

# 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 
- ![](https://i.imgur.com/i0DdZIS.png)


