Re: Incremental load from SQL server DB to postgressql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Hi,

You can use  pgloader. It is a powerful tool that can migrate data from SQL Server to PostgreSQL efficiently, and it supports incremental loads or the other option is to use file_fdw, it allows PostgreSQL to directly query flat files  as if they were tables, without importing the data into PostgreSQL. It can be useful if you can periodically export data from SQL Server into flat files and then query them from PostgreSQL.

On Thu, 5 Sept 2024 at 18:54, Sabyasachi Mukherjee <mukherjee.sabyasachi@xxxxxxxxxxx> wrote:
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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux