How to manually update data in Production? Can we access data directly?
I am a Microsoft Developer who has been tasked with taking over Mendix development and have an issue I cannot figure out. I need to change a record in the production database. In the Microsoft world, I would open Sql Server Management Studio and run an UPDATE query. Can we get direct access to the Mendix database for updates? The only option I know of in my limited Mendix experience is to have a test page with a button that runs a Microflow and in the Microflow I set the value and save it. But that means I have to deploy a new package just for this one little update. The particular table does not have a form to get access to it. It’s an internal table that stores some settings. It was not created as a Constant that I could get to through Environments. Suggestions?
There are two ways of doing this:
Create a database backup, download it, restore it locally, update it, re-upload it