RE: MSSQL to PostgreSQL Migration

From: Pascal CROZET <pascal(dot)crozet(at)metanext(dot)com>
To: Datta D <dattadeshpande(dot)it(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: RE: MSSQL to PostgreSQL Migration
Date: 2023-01-02 08:22:39
Message-ID: PAXP251MB01780E200377F70691C9FE4898F79@PAXP251MB0178.EURP251.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Datta D.

I’ve read MySql instead of MsSql :/ Sorry. I prefer to name it as SqlServer, to avoid this issue.
In this page<https://dbconvert.com/blog/migrate-data-from-sql-server-to-postgresql/>, you can found pgloader or Sqlserver2pgsql as open source tools

From: Pascal CROZET
Sent: Monday, January 2, 2023 9:12 AM
To: Datta D <dattadeshpande(dot)it(at)gmail(dot)com>; pgsql-admin(at)postgresql(dot)org
Subject: RE: MSSQL to PostgreSQL Migration

Hi Datta D

You can use ora2pg<https://ora2pg.darold.net/> that can help you to migrate also from MySql.
Moves Oracle and MySQL database to PostgreSQL

I’ve use it to migrate in cloud IaaS from Oracle to PG 14

From: Datta D <dattadeshpande(dot)it(at)gmail(dot)com<mailto:dattadeshpande(dot)it(at)gmail(dot)com>>
Sent: Sunday, January 1, 2023 7:12 PM
To: pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Subject: MSSQL to PostgreSQL Migration

Dear Admins
I am looking for a reliable open-source tool for migrating MSSQL server to Postgresql on prem cloud.
Can you please suggest a related open-source tool for migrating all objects and data?

Thanks
Datta

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Amine Tengilimoglu 2023-01-03 18:10:49 Subtransactions in PostgreSQL
Previous Message Pascal CROZET 2023-01-02 08:11:48 RE: MSSQL to PostgreSQL Migration