> ## Documentation Index
> Fetch the complete documentation index at: https://artie.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Overview

> This page provides an overview of the different ways Artie supports replicating data from Microsoft SQL Server.

## Sync methods

Artie supports the following methods for replicating data from SQL Server:

<CardGroup cols={2}>
  <Card icon="square-1" title="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.
  </Card>

  <Card icon="square-2" title="CDC with capture instances" href="/docs/sources/microsoft-sql-server/capture-instances" />

  <Card icon="square-3" title="Change tracking" href="/docs/sources/microsoft-sql-server/change-tracking" />

  <Card icon="square-4" title="Active transaction log via SQL access" href="/docs/sources/microsoft-sql-server/sql-access" />
</CardGroup>

## Additional features

<Accordion title="Single tenant databases">
  Artie offers the ability to unify tables across multiple databases into a single destination table to support single tenant databases.

  1. To get started, click "Enable unifying tables across databases" in the source tab and select the databases you want to unify
  2. In the tables tab, select the tables you want to unify
  3. 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
</Accordion>