> On 20 Aug 2025, at 19:25, KK CHN <kkchn.in@gmail.com> wrote:
(…)
> 4. Any hurdles or challenges or risks
MS SQL defaults to case insensitive string comparisons, trimming trailing white-space.
PostgreSQL defaults to case sensitive string comparisons, so incorrectly cased strings in queries that match in MS SQL
willnot match in PostgreSQL.
The trailing spaces bit is not going to matter while moving the data to Postgres, as you will not get any trailing
spacesfrom MS SQL to be stored in PostgreSQL (they’ve been trimmed already, after all) - but it could trigger some
applicationbugs where people have assumed that trailing spaces get trimmed.
Also, time zone names are wildly different between the two. MS SQL uses Microsoft Windows time zone names, Postgres
(andmost other RDBMSes) use IANA names.
Alban Hertroys
--
There is always an exception to always.
