how to two different databases automatically SYNC process. ex: 1)MYSQL----------------(dept table) 2)MS SQL SERVER ----(dept table) if one row inserted into dept table in mysql db then automatically inserted into dept table in ms sql server database. note:CDC concept is not work because CDC concept only one database.
Hi, There is no such automatically "Sync" process between two Databases. You have to compare tables to get the updated data then insert it to another DB by manual. For example: t<DB>input(targetDB Mysql)-->main-->tMap-->t<DB>output(Mssql) t<DB>input(sourceDB)-->lookup--> Make a inner join and set "Catch Look up inner join reject " as true and the processed data should be updated data, then insert it into another to keep the two database "Sync". Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
hi, as sabrina says, CDC is only available with subscription. but you can use the same by writing your own trigger to catch change on data from somes tables. google search o 'mysql DML statements trigger' Or go to an enterprise Talend version regards laurent