Could you please guide if there is a setting to specify collation property at target while replicating from 1 sqlserver to other. We want to override source property at replicated target.
Usually, collation will be set at the target side based on the characters used at the source side. We need to understand the Task configurations and Target database configurations and based on that we can suggest.
I would suggest opening a support ticket with us to analyze further.
Please take note that in SQL Server the collation is a bit different with other RDBMS. In SQL Server there are only 2 level collations: database-level, and column-level. (there is NOT table-level collations). When you create or alter a table, you can specify collations for each character-string column by using the COLLATE clause. If you don't specify a collation, the column is assigned the default collation of the database.
So far you may set the database COLLATE and Qlik Replicate inherits it.
Hope this helps.
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
