MSSQL Source: Remote Distribution Database

MichaelMockus — Fri, 21 Jan 2022 16:26:30 GMT

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?

Re: MSSQL Source: Remote Distribution Database

PGN — Fri, 21 Jan 2022 16:31:59 GMT

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

topic MSSQL Source: Remote Distribution Database in Qlik Replicate

MSSQL Source: Remote Distribution Database

Re: MSSQL Source: Remote Distribution Database