DEV Community

Maulik Paneliya
Maulik Paneliya

Posted on

1 1 1 1 1

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

Top comments (0)

Retry later
👋 Kindness is contagious

Dive into this informative piece, backed by our vibrant DEV Community

Whether you’re a novice or a pro, your perspective enriches our collective insight.

A simple “thank you” can lift someone’s spirits—share your gratitude in the comments!

On DEV, the power of shared knowledge paves a smoother path and tightens our community ties. Found value here? A quick thanks to the author makes a big impact.

Okay