WHMCS: change domain registar for existing domains

Hello,

how can i change domain registar (registar module) used for existing .tk domains?

i deactivated old domain registar WHMCS module and activated new one, but can not find way to migrate all existing .tk domains to new registar module

i can do it because registar is same, only has differently named module folder and .php script file + file is offcourse different. But the registar stays same. I just need to change from: dottk to freenom

whmcs 6.3.x

Can please suggest a MySQL UPDATE query please if not possible to do in WHMCS?

Thank you

how can i change domain registar (registar module) used for existing .tk domains?

you could change them individually by changing the registrar dropdown value in the client profile domains tab...

Can please suggest a MySQL UPDATE query please if not possible to do in WHMCS?

UPDATE tbldomains
SET registrar = 'freenom'
WHERE registrar = 'dottk';