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
