
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
MySql To Sql Server
I using MySql as a source and Sql Server as a target in qlik replicate when i run the task i got following error.
Stream component 'st_0_Mysql to sql source' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_Mysql to sql source'.
Errors in MySQL server validation.
Binary logging is disabled for MySQL server
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ZuhaibRana
you need to enable binary logging, this is one of the requirement:
Enable binary logging

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
To enable binary logging (required for CDC replication), the following parameters must be configured in MySQL’s my.ini (Windows) or my.cnf (UNIX) files.
Thanks
Lyka

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ZuhaibRana
you need to enable binary logging, this is one of the requirement:
Enable binary logging

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
To enable binary logging (required for CDC replication), the following parameters must be configured in MySQL’s my.ini (Windows) or my.cnf (UNIX) files.
Thanks
Lyka

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks. Problem Solved
