DUMP MSSQL DATABASE INTO POSTGRES
Maulik Paneliya

Maulik Paneliya @maulik2900

About: Software Developer

Location:
India
Joined:
May 8, 2024

DUMP MSSQL DATABASE INTO POSTGRES

Publish Date: Jul 26 '24
4 0

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

Comments 0 total

    Add comment