4 ms·
I think 11 months is absolutely crazy, and the context for that is that I earn for living by selling my database migration software [1]. They could have used my
by metadata 6y ago
I think 11 months is absolutely crazy, and the context for that is that I earn for living by selling my database migration software [1]. They could have used my software to copy up to 16 tables in parallel for a mere $3k. They could have copied a few hundred tables at a time, compare source and target to make sure everything is fine, then drop and compact. As more disk space frees up, they could have moved more and more data in one go. If the data needed to be transformed much, they could have wrote views to pull the data in a proper format and creating tables on the target with that data as they go.
True, spinning drives would kill performance, but my tool is easily reaching 50MB/s on SSDs and spinning drives wouldn't add months.
I mean, when you have off the shelf products doing what you need, spending so much time fighting with custom scripts is and odd choice.
This is really not meant to advertise, I'm just baffled by how much effort was needed for this project.
[1] https://www.spectralcore.com/fullconvert https://www.spectralcore.com/fullconvert