MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Wed, 20 Aug 2025 22:55:56 +0530
Message-ID: <CAKgGyB8ZZLzDVg3eCym=BMf7+8LOS-bfOE1EdXWA_X4qha_=Xw@mail.gmail.com>
Subject: MS SQL to Postgres
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b014bd063ccf44fb"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB8ZZLzDVg3eCym%3DBMf7%2B8LOS-bfOE1EdXWA_X4qha_%3DXw%40mail.gmail.com>
Precedence: bulk

--000000000000b014bd063ccf44fb
Content-Type: text/plain; charset="UTF-8"

Hi,

I am in search of the best practices to migrate from an MS SQL database
server to PostgreSQL 16

Existing DB server MSSQL with 6 Million records and 3.5 TB  with 424 Tables
running from 2019 onwards.

Each table has 5 to 16 columns ( basically text, numbers, lat long
coordinates , time stamps, and images/voice file (stored in archive
folders)reference links, etc.  ).

I am in need to port / migrate all this data from this MS SQL server to
Postgres16 .

1. What are the best methods and practices folks employ to do this kind of
data porting operations?
2. what are the tools and techniques to explored / employed for this
3. How much time is consumed by employing the right tools, the entire
porting of 6 million records of 3.5 TB size to Postgres 16 takes
4. Any hurdles or challenges or risks

Kindly enlighten me with the best practices and  reference materials /
links or tutorials to perform these operations successfully.

Thank you,
Krishane

--000000000000b014bd063ccf44fb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,=C2=A0<br><div><br></div><div>I am in search of the bes=
t practices to migrate from an MS SQL database server to PostgreSQL 16</div=
><div><br></div><div>Existing=C2=A0DB server=C2=A0MSSQL with 6 Million reco=
rds and 3.5 TB=C2=A0 with 424 Tables running from 2019 onwards.</div><div><=
br></div><div>Each table has 5 to 16 columns ( basically text, numbers, lat=
 long coordinates , time stamps, and images/voice file (stored in archive f=
olders)reference links, etc.=C2=A0 ).</div><div><br></div><div>I am in need=
 to port / migrate all this data from this MS SQL server to Postgres16 .</d=
iv><div><br></div><div>1. What are the best methods and practices folks emp=
loy to do this kind of data porting operations?=C2=A0=C2=A0</div><div>2. wh=
at are the tools and techniques to explored / employed for this</div><div>3=
. How much time is consumed by employing the right tools, the entire portin=
g of 6 million records of 3.5 TB size to Postgres 16 takes=C2=A0</div><div>=
4. Any hurdles or challenges or risks=C2=A0</div><div><br></div><div>Kindly=
 enlighten me with the best practices and=C2=A0 reference materials=C2=A0/ =
links or tutorials to perform=C2=A0these operations successfully.=C2=A0=C2=
=A0</div><div><br></div><div>Thank you,=C2=A0</div><div>Krishane=C2=A0</div=
><div><br></div></div>

--000000000000b014bd063ccf44fb--