Postgresql to MS SQL Server

Question

hi,

Using SSIS, I need to download data from snowmirror PostgreSQL to sql server.

Could anyone tell me what steps I need to take.

Answer 1

Hi @coool sweet ,

Update:

You may install the PostgreSQL ODBC driver and configure ODBC drivers to use the ODBC source to load data from PostgreSQL to MSSQL.

Here is a detailed tutorial for your reference.

ssis-with-postgresql-connect-to-postgresql-with-ssis-components

You may also Connect to a PostgreSQL Data Source via SQL Server Import and Export Wizard and then load the data.

connect-to-a-postgresql-data-source-sql-server-import-and-export-wizard

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Could anyone tell me what steps I need to take

Add a data flow task, there a data source = PostgreSql and a data destination = SQL Server.

Answer 3

You can load data from PostgreSQL to SQL Server using tds-fdw.

CREATE FOREIGN DATA WRAPPER tds-fdw;

CREATE SERVER mssql_svr FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername '127.0.0.1', port '1433', database 'tds_fdw_test', tds_version '7.1');

CREATE FOREIGN TABLE mssql_table (id integer, data varchar) SERVER mssql_svr OPTIONS (table_name 'dbo.mytable', row_estimate_method 'showplan_all');

INSERT INTO mssql_table SELECT * FROM pgsql_table;