MS SQL to Postgres
От | KK CHN |
---|---|
Тема | MS SQL to Postgres |
Дата | |
Msg-id | CAKgGyB8ZZLzDVg3eCym=BMf7+8LOS-bfOE1EdXWA_X4qha_=Xw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: MS SQL to Postgres
Re: MS SQL to Postgres Re: MS SQL to Postgres |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: