Postgres Pro
Downloads
Home   >   mailing lists

Re: OLEDB for PostgreSQL - Mailing list pgsql-performance

From Pavan Pusuluri
Subject Re: OLEDB for PostgreSQL
Date
Msg-id CAOLHn8a7114hUi-TH4NwxOnP_BO_W6hmCf_Tm=EOHafsSa0H8Q@mail.gmail.com
Whole thread Raw
In response to Re: OLEDB for PostgreSQL  (aditya desai <admad123@gmail.com>)
List pgsql-performance
Tree view
I have been using SSIS for migrating data only for non-aws stuff.

If your target is on AWS, you can use SCT nd DMS.

You might also want to look into the link....https://youtu.be/YKJub0zVztE


Regards
Pavan


On Mon, Apr 19, 2021, 8:10 AM aditya desai <admad123@gmail.com> wrote:
Hi Mustafa,
You can look into the SQLine tool. We recently used to migrate MSSQL to PostgreSQL. For procedures/functions etc you need to have good amount of understanding of TSQL and PL-PGSQL. SQLine will convert 60-80% of you TSQL code. Some manual effort is required at the end.

Regards,
Aditya.

On Fri, Apr 16, 2021 at 4:03 PM <mustafa.pekgoz@forenda.com.tr> wrote:

Hello,

 

We want to start migration to POSTGRESQL13 from  MSSQL SERVER  but we couldnt find any solution for oledb drivers. Please help us to find a solution or any workaround if possible.

 

 

 

Thanks.

Mustafa

pgsql-performance by date:

Previous
From: Jeremy Schneider
Date:
Subject: Re: Planning performance problem (67626.278ms)
Next
From: David Rowley
Date:
Subject: Re: Planning performance problem (67626.278ms)