DUMP MSSQL DATABASE INTO POSTGRES

maulik2900

Maulik Paneliya

Posted on July 26, 2024

DUMP MSSQL DATABASE INTO POSTGRES

1. Install pgloader into system:

Download pgloader

OR Run

$ apt-get install pgloader

2. create config file and add below code to file: [ex: pgloader.conf]

load database
from mssql://Username:Password@Host:Port/dbname
into postgresql://Username:Password@Host:Port/dbname
ALTER SCHEMA 'dbo' RENAME TO 'public';

3. run following command in terminal:

pgloader pgloader.conf

Click here for more info

Thank You

💖 💪 🙅 🚩
maulik2900
Maulik Paneliya

Posted on July 26, 2024

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related