Is there any possible way to convert PostgreSQL database to MS SQL Server?

Question

I am using Postgres db. I need to migrate this database to Microsoft SQL Server database. Is there any possible way?

rennf93 · Accepted Answer · 2022-10-19 14:52:12Z

1

Use this command:

pg_dump -U username your_db_name > db_backup.sql --column-inserts

The --column-inserts option generates INSERT statements possible for each row of data and should be compatible, but you may have to change the syntax just a little bit. (And it may cause data-loss, https://www.postgresql.org/docs/current/app-pgdump.html)

Then just simply open the .sql file and run it inside SqlServer

answered Oct 19, 2022 at 14:52

rennf93

617 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

rennf93 Over a year ago

There's also some tools out there: dbsofts.com/articles/postgresql_to_sql_server And I'd also suggest to check this answer from a similar question: stackoverflow.com/a/6567036/6104961

Amith Thillenkery Over a year ago

I tried that tool. But not working for me.

Collectives™ on Stack Overflow

Is there any possible way to convert PostgreSQL database to MS SQL Server?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related