Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
MichaelMockus
Contributor III
Contributor III

MSSQL Source: Remote Distribution Database

Configuring a MSSQL source connection for Qlik Replicate. The instruction specify,

In the Distributor step, select <Microsoft SQL Server Name> will act as its own distributor; Microsoft SQL Server will create a distribution database and log.

First assumption is that if the databases is already using MSSQL Replication and a distribution DB this can be skipped.

Will Replicate properly if this distribution database is a remote server and NOT local to the datasource?

Labels (1)
1 Reply
PGN
Creator II
Creator II

Yes, a remote distributor will work fine.  I recommend a remote distributor especially if you're using Availability Groups.