Thread: Re: OLEDB for PostgreSQL
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
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