My PostgreSQL Migration Is Complete

project postgresql database
PostgreSQL logo over blurred gray background

My migration from MySQL to PostgreSQL is complete. I managed to finish staging my data last night, and I had planned on making all of the necessary code changes over the weekend. After looking at what I had left in my list, I found that it was not really that bad. My digital twin was the largest piece of it, and the most problematic part of that was finding the ideosyncracies between the SQL syntax of MySQL and PostgreSQL. It boiled down to small things like RAND() vs RANDOM(). I'll turn the log level back down after a few days. I did notice that I was not consistent with how I handled parameterized SQL in a few places. I will need to research what the current conventions are. Overall, everything seems to be working well enough that I shutdown my MySQL instance. I have a dump of the database if I find any major issues. In any case, that vast majority of the work is complete, and I can move on to other things.

Previous Post Next Post