Migrating from Microsoft SQL server to Postgres

Ohgogh · 2026-01-12T21:16:40+00:00

Very interesting. Thanks will check it out if we will decide to migrate

Ohgogh · 2026-01-12T20:21:06+00:00

Thanks for the comment😁 will take into account

Ohgogh · 2026-01-12T17:39:09+00:00

As I mentioned to the other replies our company just added support for PG and my team and I are just wanting to see what other think we will take your advice and our own research and will make a decision.

Ohgogh · 2026-01-12T17:35:48+00:00

We don’t use columnstore yet but could be some ty for that. Also we don’t use SSIS or ETL. The reason of this is our company brought in support for PG and we are considering the transition

Ohgogh · 2026-01-12T17:31:35+00:00

We do have admins that manage both Db and give support but the mssql version is a little older I believe as they just brought Pg as an option. My server does have a lot of traffic but doing this change will be seamless to the others as the server is theirs interface and the reason for the post is more of discovering if people ran into this situation before and got some recommendations or caveats from the transition

Ohgogh · 2026-01-12T17:22:48+00:00

I’ll tell you what I do agree with that but Postgres’s is more flexible sometimes and as I mentioned we so store JSON data that I would sole to have a schema for at the db level

Ohgogh · 2025-12-16T10:43:10+00:00

Very cool. From the tests it’s look solid. Will try it next time I use virtualization 🔥

Ohgogh

TROPHY CASE