I have a question regarding a custom category attribute that was added via a module/extension in a Magento 1.9.4.1 webshop and now is migrated correctly to the Magento 2 webshop (2.3.4). I checked the database manually with phpmyadmin to see if the attribute was migrated correctly, since it's not showing up in the backend. I found the attribute with ID 180 and saw that the values were migrated correctly.
I went ahead and changed the frontend template to show these values correctly. That worked out pretty well. It now shows the values correctly on the frontend. FYI this attribute holds some text (a description) regarding the category.
Next thing i wanted to do is, show this attribute in the backend at the category edit page. I'm wondering how this could be achieved. I already told you that in the M1 1.9.4.1 shop, this attribute was added via a custom extension, that uses the mysql installer to install the custom attribute in the database. Since the data is already migrated and in the M2 database, i was wondering: Do i need to create a new custom extension for M2 with the same mysql installer settings for this category attribute?
My worry is that if i do it this way, it will create another category attribute and that i need to transfer the data over to this new attribute. Will the mysql installer see that there already is a category attribute with the name: 'custom_attribute' and ignore the creation of a new attribute and instead just shows the attribute in the backend?
I hope someone can help me with this, since i don't want to ruin a perfect migrated webshop. Thanks in advance :)