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)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more