How to export data from SQL Server to PostgreSQL?

Question

I need to export all tables from SQL Server to PostgreSQL.

Try: I tried from SQL Server IDE but at some stage its giving the error about data types are different.

Question:How can I do export of data from SQL Server to PostgreSQL? Is COPY does my job? If yes, then how can I export all tables including records?

Answer 1

You can't export data from MSsql then import to PostgreSql because it is not same syntax, data type, but you can use tool to migration data from mssql to postgreSql, See more in topic migrate data from MS SQL to PostgreSQL?