Sync methods
Artie supports the following methods for replicating data from SQL Server:Transaction-log backups
Read completed SQL Server transaction-log backup (
.trn) files from a filesystem directory accessible to your Artie data plane. Artie extracts committed row changes and replicates them through your pipeline. Replication latency depends on your log-backup cadence and the configured polling interval.CDC with capture instances
Change tracking
Active transaction log via SQL access
Additional features
Single tenant databases
Single tenant databases
Artie offers the ability to unify tables across multiple databases into a single destination table to support single tenant databases.
- To get started, click “Enable unifying tables across databases” in the source tab and select the databases you want to unify
- In the tables tab, select the tables you want to unify
- If your primary key is not globally unique, you have the option to use the full source table name (
dbName.schemaName.tableName) as part of the primary key