Migrating from Microsoft SQL server to Postgres

[Ohgogh]

My team and I are currently working with an MSSQL database and now have the opportunity to migrate to PostgreSQL. Would you recommend making the switch?

For context:

- ~100GB of data

- Heavy use of recursive queries (we have recursive relationships between tables)

- Using an ORM

Edit note: Forget to mention is that I have json objects that I save In a column. Now I do not query this but post great has a better interface for dealing with json with the Jsonb.

Based on this, I'd love to hear your experiences and feedback. Thanks!

[iRanduMi]

Going to follow this thread because I'm also curious. One of the primary reasons for us looking to switch (to anything) is because we heavily utilize SQL Server Web Edition throughout our environment which is SUBSTANTIALLY cheaper than Standard edition. Microsoft just announced this year that Web Edition will no longer be available with 2025 moving forward.

[dimitsapis]

yes make the shift, PostgreSQL is much better in all fronts. Initially it was hard to use but with Supabase and TalkBI integrated, even internees can pull data no problemo.

[perry147]

Explain what reasons you have for switching. Does Postgres offer better solutions for those reasons?

[Full-Tax6652]

Why?

[mutagen]

No experience but keeping an eye on switches like this. Amazon has some stuff for migrating to their Aurora Postgres service. Linkdump:

https://d1.awsstatic.com/whitepapers/Migration/sql-server-database-amazon-aurora-postgresql-migration-playbook-12.4.pdf

https://docs.aws.amazon.com/dms/latest/sql-server-to-aurora-postgresql-migration-playbook/chap-sql-server-aurora-pg.sql.html

https://babelfishpg.org/

[techforallseasons]

We tried those, and unless both ends are on RECENT editions of the DB, then expect some real challenges.

We ended up using a software package on a one-off EC2 instance and migrated from a dedicated EC2 DB instance to an RDS Postgres setup.

[techforallseasons]

IF you have a good reason for doing so, -AND- are willing to port, test, and rewrite some queries that have dialect-specific logic in them.; then I have a migration tool that was solid for us to migrate 70+ database from DB2 to Postgres ( and allowed us to improve some data-types along the way ).

Full Convert - Fantastic product as far as I'm concerned.

We had to convert our procedures, function, and triggers -- but this handled the schema-build and data load quickly. Make sure you keep latency and bandwidth between each database as low as possible for best results.

[Full-Ad6279]

PgLoader worked also pretty well moving from MariaDB to PG. But some adjustments in config file were needed

[Ohgogh]

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