Moving contribution from individual to organization

Question

I have a contact in CiviCRM that is of contact-type Individual in CiviCRM. In real life, this is an organization.

I want to convert this contact from an Individual to an Organization. How do I do that?

(I could just delete the contact, and create a new contact, but I really want to keep the contribution history. So then I would need to move that from one contact to another. Using merge contacts only works within same contact-type. So this solution doesn’t seem to work either)

Answer 1

Alternatively - you can try install/use:

https://civicrm.org/extensions/move-contribution

Answer 2

Run below query in mysql

UPDATE civicrm_contact
SET contact_type = 'Organization',
organization_name = sort_name
WHERE id = 123;

123 is a contact id