undefined | Better HN

0 pointssetr4y ago0 comments

IME if you didn’t use the DB -specific features, migration is painful, but not that much so.

If you did use the DB specific features, you’re screwed regardless of an ORM.

NB: I work for a DB migration firm, specializing in legacy->modern — where our usual customer has thousands of SP’s that have to be migrated and an ORM would have saved you maybe 5% of the effort; so my experience is biased towards that level of difficulty.

0 comments

1 comments · 1 top-level

sumtechguy4y ago

TSQL and PSQL ideas of a stored procedure are not really the same.

If your SQL is mostly bound columns or some sort of ORM only then you can get lucky and just play the data type matching game. But most of the ones I have ever had to port was playing the 'rewrite these 300 stored procs again' game. They usually ended up in some sort of stored procedure for one of a few reasons 'they only knew how to do that', performance, that is what the senior guy wants.

j / k navigate · click thread line to collapse