public inbox for [email protected]  

help / color / mirror / Atom feed

From: KK CHN <[email protected]>
To: [email protected]
Subject: MS SQL to Postgres
Date: Wed, 20 Aug 2025 22:55:56 +0530
Message-ID: <CAKgGyB8ZZLzDVg3eCym=BMf7+8LOS-bfOE1EdXWA_X4qha_=Xw@mail.gmail.com> (raw)

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

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: MS SQL to Postgres
  In-Reply-To: <CAKgGyB8ZZLzDVg3eCym=BMf7+8LOS-bfOE1EdXWA_X4qha_=Xw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox