Migrate sql enterprise rds database to postgresql

Question

Migrate sql enterprise rds database to postgresql

Frank Christiansen 21

Hi,

I am asked at work if it migrate an SQL Enterprise database to Postgresql.
The database is used for RDS that supports 50 jumpservers.
I have not done migrations like this before, so I guess my first question is, is it at all possible?

Best Regards
Frank

1 answer

Your answer

Answer 1

Bruce (SqlWork.com) 77,686 Volunteer Moderator

Sure it's possible.

The difficulty will be on how ansi sql your sqlserver is. SqlServer has its own datatypes, that might not map directly. also the its transact sql is different, so stored procedure definitions and calls are different. You should do a POC to see how complex the migration is.

you should also check for any migrations the client code may require and that it uses sql drivers compatible with PostgreSql. the client code may also be using SqlServer features that require rework.

So the scale of the project depends on the current database schema and client codebase.

Frank Christiansen 21 Reputation points

2025-05-13T10:35:06.43+00:00

Thank you very much. I can read from your answer that we need a postgresql/ms sql experts. While we to a certain extend have personal capable of administrating ms sql, we lack the same knowlegde on postgresql. If we do it migration it should be relatively simple and without challenges that requires us to make complex changes.

In your opinion would you also consider this to be the correct approach not to do it?

Share via

Migrate sql enterprise rds database to postgresql

1 answer

Your answer