Option use ELT tool , if PostgreSQL in Azure use Azure Data Factory Option 2 , write SQL statements to extract data in PostgreSQL format , load into PostgreSQL using \copy command If AWS use Schema Conversion Tool (SCT) along with Database Migration Services (DMS) From: Sabyasachi Mukherjee <mukherjee.sabyasachi@xxxxxxxxxxx> Hello All, I have to implement an incremental load from a SQL server DB to a postgresql DB. I would prefer it to be pull from postgres. SSIS is not the preferred option. Can you please advise about the possibilities? Sabyasachi Mukherjee |
