Targets
Relational databases
Replicate into PostgreSQL, MySQL, Oracle, SQL Server, Azure SQL, SQL database in Fabric or Sybase ASE, with source transactions applied in commit order.
A relational target receives the source's changes as SQL. SQL Flow first loads every selected table, then applies inserts, updates and deletes in source transactions, in commit order.
Targets in this group
| Target | Highlights |
|---|---|
| PostgreSQL | PostgreSQL databases, with TLS and certificate validation by default |
| MySQL | MySQL and MariaDB, with TLS and certificate validation by default |
| Oracle | Set-based or ordered apply, and Oracle-to-Oracle object and VARRAY types |
| SQL Server | Exactly-once apply, and encryption into Always Encrypted columns |
| Azure SQL | Azure SQL Database and Hyperscale, Microsoft Entra identities, and Always Encrypted columns |
| SQL database in Fabric | A SQL database in Microsoft Fabric, connected with Microsoft Entra |
| Sybase ASE | SAP ASE databases, with changes applied in source order |
Every source and capture mode writes to every target in this group. See Supported sources and targets.
What every relational target does
- Initial load, then changes. The initial load copies each selected table. Streaming then applies each source transaction as a transaction on the target.
- Target tables. SQL Flow creates the tables when you choose Prepare target schema on the wizard's Prepare step, and shows the SQL first. You can also create the tables yourself.
- Committed position on the target. SQL Flow keeps the pipeline's position on the target, so a restarted pipeline, or another agent that takes over, resumes from what the target holds.
- Mapping and processing. Name mapping and in-flight processing apply per target.
- Validation. Compare checks the target against the source, and repair fixes the rows that differ.
- Reload. Reload empties the target's tables and loads them again.
Each target's page lists its requirements, the permissions its login needs, what SQL Flow creates there, its options and its limitations.
