Postgres Pro
Downloads
Home   >   mailing lists

Re: Migration from SQL Server to PostgeSQL - Mailing list pgsql-general

From Thibaut Madelaine
Subject Re: Migration from SQL Server to PostgeSQL
Date
Msg-id 867631e1-3179-10c6-9904-c0d65617e06b@dalibo.com
Whole thread Raw
In response to Migration from SQL Server to PostgeSQL  ("Muthukumar.GK" <muthankumar@gmail.com>)
List pgsql-general
Tree view


Le 30/11/2020 à 06:11, Muthukumar.GK a écrit :
HiTeam,

We need to migrate tables,Records,Procedure and function from SQL server to Postgresql. Kindly let me know, Is there any  tool or easiest way  available to migrate from SQL Server to Postgresql. Please let me know if there are any limitations in postgresql compared to SQL server.

Regards
Muthu.

Hello Muthukumar,

We maintain a tool to migrate from SQL Server to PostgreSQL: sqlserver2pgsql

You can use it to convert your SQL schema.
It can generate Pentaho Data Integrator (Kettle) job to migrate all the data.

Unfortunately , it does not migrate procedures and functions. Transact-SQL is very different from PostgreSQL's many PL languages. These would need a manual migration.

Hope this tool can be of any help!

Cordialement,

Thibaut

-- 
Thibaut Madelaine
Dalibo Support PostgreSQL
Attachment

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Storage and querying of filesystem paths
Next
From: Nick Cleaton
Date:
Subject: concurrent re-partitioning of declarative partitioned tables