This content originally appeared on DEV Community and was authored by Maulik Paneliya
1. Install pgloader into system:
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
Thank You
This content originally appeared on DEV Community and was authored by Maulik Paneliya
Print
Share
Comment
Cite
Upload
Translate
Updates
There are no updates yet.
Click the Upload button above to add an update.
APA
MLA
Maulik Paneliya | Sciencx (2024-07-26T12:56:08+00:00) DUMP MSSQL DATABASE INTO POSTGRES. Retrieved from https://www.scien.cx/2024/07/26/dump-mssql-database-into-postgres/
" » DUMP MSSQL DATABASE INTO POSTGRES." Maulik Paneliya | Sciencx - Friday July 26, 2024, https://www.scien.cx/2024/07/26/dump-mssql-database-into-postgres/
HARVARDMaulik Paneliya | Sciencx Friday July 26, 2024 » DUMP MSSQL DATABASE INTO POSTGRES., viewed ,<https://www.scien.cx/2024/07/26/dump-mssql-database-into-postgres/>
VANCOUVERMaulik Paneliya | Sciencx - » DUMP MSSQL DATABASE INTO POSTGRES. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/07/26/dump-mssql-database-into-postgres/
CHICAGO" » DUMP MSSQL DATABASE INTO POSTGRES." Maulik Paneliya | Sciencx - Accessed . https://www.scien.cx/2024/07/26/dump-mssql-database-into-postgres/
IEEE" » DUMP MSSQL DATABASE INTO POSTGRES." Maulik Paneliya | Sciencx [Online]. Available: https://www.scien.cx/2024/07/26/dump-mssql-database-into-postgres/. [Accessed: ]
rf:citation » DUMP MSSQL DATABASE INTO POSTGRES | Maulik Paneliya | Sciencx | https://www.scien.cx/2024/07/26/dump-mssql-database-into-postgres/ |
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.