Does Fivetran Replicate Indexes From SQL Server to SQL Server?

Question

Does Fivetran replicate indexes from my source SQL Server tables to my SQL Server destination?

Environment

• Connector: SQL Server
• Destination: SQL Server

Answer

No, we don't replicate indexes defined on your source SQL Server tables to your destination. The destination contains only the primary key indexes that SQL Server creates automatically.

We don't replicate secondary indexes, unique constraints, or foreign keys. If you require these objects in your destination, you must create and maintain them manually.