Re: MS SQL to Postgres

> On 20 Aug 2025, at 19:25, KK CHN <kkchn(dot)in(at)gmail(dot)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 will not 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 spaces from MS SQL to be stored in PostgreSQL (they’ve been trimmed already, after all) - but it could trigger some application bugs 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 (and most other RDBMSes) use IANA names.

Alban Hertroys
--
There is always an exception to always.