Note
Currently, Replicate Preview supports data replication using the Snapshot type.
Mirroring replication mode is available in the Syniti Replicate desktop version and will be supported in future releases of the cloud version.
Snapshot
The Snapshot replication type is a one-time or continuous complete replication from the source to the target table based on the replication configuration. You can schedule the replication, identify the columns to be replicated, and add source filters during replication. The source and target databases can be on the same or different database servers and platforms. For example, you can replicate a SQL Server table to an Oracle database or a SQL Server table to a PostgreSQL table.
In the Snapshot replication type, you can snapshot data from different databases from one or more source datastores to a single target datastore. Depending on your replication settings, Snapshot replications will perform one of these processes:
Snapshot Process | Description | Append Mode Toggle | Drop Target Table Toggle |
|---|---|---|---|
Truncate and Insert | Truncates all records in the target table before inserting records from the source table. This process is default for Snapshot replications. | False | False |
Append | Appends new data from the source table without truncating data in the target table. | True | False |
Drop, Recreate, and Insert | Removes (drops) the entire target table, recreates it, and then inserts data from the source table. | False | True |
Note
You can also drop a target table for truncation and append mode replications using the Drop Target Table icon in the Actions column.