Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Defining Microsoft SQL Server database settings

Set the following for the Microsoft SQL Server database(s) you are using as a source:

  • From the Object Explorer in the Microsoft SQL Server Management Studio, right click the database and select Properties. In the Options tab, set the Recovery model to Bulk logged or Full. In this mode, the transaction Log is more durable and truncation occurs less frequently.
  • Ensure that there is a full database backup for each Microsoft SQL Server database that you are using as a source.
  • When creating a connection string, it is possible to use any parameter supported by Microsoft SQL Server. The Microsoft SQL Server system administrator must ensure that the Microsoft SQL Server instance is configured correctly so that the proper authentication credentials are accepted.
  • To be able to work with MS-REPLICATION, each of the source tables must have a primary key.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here