I have run into an issue when running testing on legacy unmanaged databases. They fail to create the necessary tables. Research shows this is because they are unmanaged the test sequencer (probably wrong name) does not create the table. The “best” solution I can find is to temporarily switch all the tables to managed for the test, then switch back to unmanaged. These articles also come with health warnings about migrations and changes not being registered. I could be wrong, but this feels like a fudge?
I am using out of the box tests and my question is that before I head into this particular rabbit hole, is there a better option out there that is designed to work with legacy databases?