Hey guys,
Our stack is getting a bit messy. Most of our legacy stuff is on SQL Server, but some of our newer microservices are running on Postgres. Managing schema changes between Dev and Staging is becoming a nightmare because I'm constantly switching between different tools.
I need to find a way to audit schema drift and generate ALTER scripts without paying for two separate enterprise licenses. Security is also a big thing for us—it has to be an offline/local tool (no cloud-based DB connections allowed).
Is there any lightweight, cross-platform tool that handles both? I'm tired of running a Windows VM just to do a quick diff on a SQL Server schema when I'm working on my Mac/Linux machine.
What’s your workflow for handling migrations when you're stuck between two different DB engines?