Skip to main content

Setting up Microsoft SQL Server for replication

If you are using Microsoft SQL Server as the source in a Qlik Replicate task, you need to enable your Microsoft SQL Server database for MS-REPLICATION.

In the Microsoft SQL Server’s Management Studio, follow the instructions provided by the Configure Distribution wizard to set up replication or see the Microsoft SQL Server documentation.

To open the wizard from Microsoft SQL Server:

  1. In the Microsoft SQL Server Management Studio, right-click the Replication folder and select Configure Distribution.

    The Configure Distribution wizard opens.

  2. Make the following selections:

    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.