Have you had experience porting an application from using MSSQL to PostgreSQL?

Question

PostgreSQL

Hello IT colleagues!
There was a task to get rid of super expensive Microsoft SQL Server. And transfer the application using this database to PostgreSQL (or another database). Perhaps there are somewhere ODBC drivers for translation / conversion of requests?
Can anyone come across

Answer 1

Listen, if you are not satisfied with the price of MS SQL Server, then the easiest way would be to do this:
1) create a backup copy of your database at work
2) download MS SQL Server Express - this is the same DBMS that you have at work, only no backup scheduler and many goodies. But! - it works great in production, we use the Express version at work - it's free, it installs quickly, it's 10 times easier to set up! And the transfer of the database will generally be in a few clicks. Those. just take the same MS SQL (depending on what year you have, 2008, 2012 ..) and download the free version from the microsoft site.
3) go through Management Studio and upload a copy of your working one to an empty database. all!
What PostgreSQL???? to transfer a database from SQL Server to Postgre you have to be... ridiculous. It's almost unrealistic. Take the same DBMS, only a free option! many services will be missing in it, but you will not need them. and just copy your database. Suggest this option to your management.

Answer 2

https://wiki.postgresql.org/wiki/Microsoft_SQL_Ser...
The experience was transferring from Oracle to psql, but everything was relatively simple there.

Answer 3

if there is a lot of data, then miraculously it will not work: like "easy" switching using ORM can still run into raw sql queries, which, moreover, are tied to DB - specific data types,
and there are also procedures / triggers that also depend on DB
and since you do not have Access, but SQL Server, it is unlikely that your application is simple and there is little data in it