News for hackers. Stuff that matters.
Re:Open-Source Babelfish for Postgres by XorNot on Thursday October 28, 2021 @05:46PM (#29032475)
Well this is a big deal for me: my father has run his business off a sprawling MS Access application which I've struggled at various times to try and move to something more modern with no success.

I wonder if this will work for connecting to MS Access directly.

Re:Open-Source Babelfish for Postgres by snerbles on Thursday October 28, 2021 @08:53PM (#29034008)
If the MS Access application is backed by an actual MS SQL server, maybe. But if (and in my experience this is more likely) it uses MS Access itself with MDB files (Microsoft's Jet database engine - imagine SQLite but inferior in every conceivable way), you're probably better off writing a tool in .NET or similar to migrate the data.

In a past job supporting an industrial controls firm, I wrote an interactive merge tool for AutoCAD Electrical parts catalog files (hideous little MDBs behind the scenes)...it was an unholy clusterfuck of C#, Lucene, NodeJS, and a smidgen of VueJS on the frontend. Not my proudest work, but it sure beat the usual tasks involving VBA in FactoryTalk.