Thread: Re: OLEDB for PostgreSQL

Re: OLEDB for PostgreSQL

From
aditya desai
Date:
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

Re: OLEDB for PostgreSQL

From
Pavan Pusuluri
Date:
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